1 / 26

LAZY ADMIN 101: Windows, SQL & System Center

LAZY ADMIN 101: Windows, SQL & System Center. Brad Watts, Timothy McAliley, Dmitri Brown , Phillip Bracher & Chris Maiden. Windows Administration. Brad Watts. Demo. Server 2012 Server Manager Tips, Tricks & Items to know PowerShell Tips, Tricks & Items to know. Useful Links.

devi
Download Presentation

LAZY ADMIN 101: Windows, SQL & System Center

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. LAZY ADMIN 101:Windows, SQL & System Center Brad Watts, Timothy McAliley, Dmitri Brown, Phillip Bracher & Chris Maiden

  2. Windows Administration Brad Watts TechGate 2013 – Reston, VA

  3. Demo Server 2012 Server Manager Tips, Tricks & Items to know PowerShell Tips, Tricks & Items to know

  4. 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)

  5. 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

  6. SQL Administration Timothy McAliley TechGate 2013 – Reston, VA

  7. KEY DBA TASKS • Maintain Your SQL SERVER • Know What is Running On Your Server • How is Your Server Performing • Backup Strategy

  8. 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

  9. 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

  10. 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

  11. Twitter HashTag #sqlhelp • Pose a question/ask help on Twitter with #sqlhelp and get feedback in minutes • Community monitored • DEMO • The #sqlhelp twitter feed

  12. System center configuration managerAdministration Dmitri Brown TechGate 2013 – Reston, VA

  13. 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

  14. 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-tool-powershell-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/

  15. Common Client Installation methods • Client Push Installation • Software update Point Based • Group Policy Installation • Logon Script Installation • Manual InstallationDEMO • Download, Review and Execute the SCCM client installation (Rmtclient.cmd)

  16. Client Installation Challenges • 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

  17. 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

  18. Failed vs Success client installs

  19. 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=0-38&sp=-1&sk=&cvid=b1347f8e30194f31afdc73a31d4a9bc6

  20. System Center Operations ManagerAdministration Phil Bracher Chris Maiden TechGate 2013 – Reston, VA

  21. 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

  22. 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 Reportingserver

  23. 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.

  24. 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.

  25. 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/

  26. Thank You techgate@hotmail.com An email will be sent to all attendees on Monday, September 21 announcing location of slides received from presenters.

More Related