LAZY ADMIN 101: WINDOWS, SQL & SYSTEM CENTER Brad Watts, Timothy McAliley, Dmitri Brown, Phillip Bracher & Chris Maiden WINDOWS ADMINISTRATION Brad Watts TechGate 2013 – Reston, VA September 21, 2013 DEMO Server 2012 Server Manager Tips, Tricks & Items to know PowerShell Tips, Tricks & Items to know USEFUL LINKS • 94 Windows 7 tips, tricks and secrets • 60 Windows 8 tips, tricks and secrets • 57 Tips Every Admin Should Know • Tips and tricks for remotely administering workstations • PowerShell Tips and Tricks • PowerShell Book (Windows PowerShell in Action) USEFUL LINKS • E-Books • • • • Windows Server 2012 and its hardware requirements Microsoft's evolving app strategy Windows Server 2012 boosts IT capabilities View All E-Books • E-Zines • Modern Infrastructure • View All E-Zines • E-Handbooks • • • • Windows Server 2012 migration station Identity management in the era of cloud and mobility Evaluating hardware for Windows Server 2008 R2 View All E-Handbooks SQL ADMINISTRATION Timothy McAliley TechGate 2013 – Reston, VA September 21, 2013 KEY DBA TASKS • Maintain Your SQL SERVER • Know What is Running On Your Server • How is Your Server Performing • Backup Strategy GREAT RESOURCES TO MAKE A DBA’S LIFE EASIER • Ola Hallagren • http://ola.hallengren.com • Brent Ozar • www.brentozar.com • Both Are Great Sites for Awesome scripts • Twitter HashTag #sqlhelp • Pose a question/ask help on Twitter with #sqlhelp and get feedback in minutes OLA HALLAGREN • Maintenance.sql • • • • • • Free Download (or download by job type) Community vetted Configures Jobs Backups Updates Statistics Index Maintenance • DEMO • Review Ola Hallagren’s Site • Download, Review and Execute the Maintenance.sql script BRENT OZAR • Both Free, Community vetted downlodn • Sp_Blitz.sql • Windows App or SQL script • Does a through server instance configuration, performance, and health check • Sp_BlitzIndex.sql • Does a through check of your database indexes • DEMO • Review Brent Ozar’s script site • Download, Review and Execute the sp_blitz.sql and sp_blitzindex.sql scripts TWITTER HASHTAG #SQLHELP • Pose a question/ask help on Twitter with #sqlhelp and get feedback in minutes • Community monitored • DEMO • The #sqlhelp twitter feed SYSTEM CENTER CONFIGURATION MANAGER ADMINISTRATION Dmitri Brown TechGate 2013 – Reston, VA September 21, 2013 DAILY, WEEKLY & MONTHLY TASKS Administrator's Guide for Reliability Workbooks Word document and spreadsheet which assists with the “how to” implement the tasks within your environment. http://go.microsoft.com/fwlink/?LinkId=189220 SCCM daily weekly monthly Maintenance Task.xlsx Compiled from http://technet.microsoft.com/en-us/library/bb632564.aspx ADD ON TOOLS TO ASSIST WITH CLIENTS SCCM Client Actions Tool PowerShell Edition aka PoshCAT (CM2007 & CM2012) http://blog.coretech.dk/kaj/sccm-client-actions-toolpowershell-edition-aka-poshcat/ Client Actions Tool is a practical and simple HTA application for performing most common day-to-day administrative tasks on System Center Configuration Manager clients. The tool allows running actions remotely on one or more computers. A list of computers can be provided either from a file (XLS, XLSX, CSV, TXT), loaded from SCCM collection or simply entered as a text into a text area. The main goal for creating this tool was to have something simple that doesn’t have any prerequisites and doesn’t require installation. Client Center by Roger Zander http://sourceforge.net/projects/smsclictr/ COMMON CLIENT INSTALLATION METHODS • Client Push Installation • Software update Point Based • Group Policy Installation • Logon Script Installation • Manual Installation DEMO • Download, Review and Execute the SCCM client installation (Rmtclient.cmd) CLIENT INSTALLATION CHALLENGES Why clients fail to install • The client is behind a firewall • MP not working as a result of which the policies are not getting downloaded • Clients going to NO after it had reported • Unable to get the site code • Incorrect discovery scan settings WHY CLIENTS FAIL TO INSTALL • The client is behind a firewall • MP not working as a result of which the policies are not getting downloaded • Clients going to NO after it had reported • Unable to get the site code • Incorrect discovery scan settings FAILED VS SUCCESS CLIENT INSTALLS EXCELLENT SOURCE OF RESOURCES • http://technet.microsoft.com/en-us/library/bb632742.aspx • http://www.bing.com/search?q=sccm+tips+and+tricks+for+administration& qs=n&form=QBRE&pq=sccm+tips+and+tricks+for+administration&sc=038&sp=-1&sk=&cvid=b1347f8e30194f31afdc73a31d4a9bc6 SYSTEM CENTER OPERATIONS MANAGER ADMINISTRATION Phil Bracher Chris Maiden TechGate 2013 – Reston, VA September 21, 2013 KEY TASKS • Maintain System Center Operations Manager (SCOM) Database Backups • Maintain SCOM Management Pack Backups • Ensure that all Management Servers are in a Healthy State • How are your Management Servers Performing? • Check SCOM Agent Health State • Checks • Daily • Weekly DAILY CHECKS • • • • • • Review all Active Alerts in the Console. Verify that there are no agents stuck in Pending Management. Verify that there are no agents in a grey state in Health Explorer. Verify Management Servers are agent Load Balanced. Review the Health Explorer for Agents listed as Critical/Not Monitored. Review the Alerts for the Management Group. • Investigate any alerts related to the SCOM Infrastructure. For Example: • Management Servers • SCOM SQL Servers • SCOM Reporting server DAILY CHECKS (cont.) • Ensure that all SCOM related custom SQL jobs ran successfully. • Ensure that Reporting is working. • Check the State of the SCOM Backups. • Verify healthy status of Web Console. WEEKLY CHECKS • Review the Most Common Alerts Report and Most Common Events Report. • Team Meeting Weekly • Review SCOM Operational Database (DB) and Datawarehouse (DW) Backup Schedule. Verify successful backup of DB and DW. • Review backup of Management Packs and Override Management Packs. • Review database free space report for DB and DW in SQL. Ensure free space is >40% for both databases. • Review Management Pack Life Cycle. REFERENCES • Getting Started with Operations Manager 2012 • http://technet.microsoft.com/en-us/library/hh509025.aspx • System Center Team Blog • http://blogs.technet.com/b/systemcenter/ • Kevin Holman’s System Center Blog • http://blogs.technet.com/b/kevinholman/ • System Center Central • http://www.systemcentercentral.com/ An email will be sent to all attendees on Monday, September 21 announcing location of slides received from presenters.