1 / 25

Central Management Server

Learn how Central Management Server (CMS) can help you centrally manage your SQL Server environment, enforce standards, and monitor compliance. Discover how to register multiple servers and use Enterprise Policy Management Framework (EPM) for efficient management. Get insights on things to consider and best practices.

mcdonalddiana
Download Presentation

Central Management Server

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. CentralManagementServer Managing Your SQL Server Environment

  2. Introduction • AJ Mendo • Email: ajmendo@poriver.com • Blog: http://sqlaj.wordpress.com • Twitter: http://twitter.com/#!/SQLAJ/

  3. What We Will Cover • What is CMS • Things to Consider • Discovering Your Environment • Registering Multiple Servers • EPM • Demo

  4. What Is CMS • Single Instance of SQL Server • Server can’t be in a group it manages * • SQL 2008 Standard or higher • Can administer SQL 2000, 2005, 2008 and R2

  5. How Can CMS Help UsBring Down the Hammer • Centrally Manage Your Environment • Enforce Standards/Consistency across all servers • Compliance Monitoring (HIPAA, SOX) • Notified when changes occur / Prevent changes

  6. Security • Windows Authentication • Servers must be in domain • Connections executed with (current) user context

  7. Things To Consider • CMS vs. Locally Registered Servers • Network Monitors CMS logging vs. your login

  8. Remote Into Server • Only when necessary – WHY? • Each session consumes the first 2GB of server memory from the Kernel. • Users share • Disk access • RAM • Network Access • Server hardware • Access global objects

  9. Folder Structure • Planning For Growth • Offset Folders 7000/700000/750000

  10. Add Project Folders

  11. Discovering Your Environment • Microsoft Assessment and Planning Toolkit (MAP) • Free * • Low level scan your environment and “find” your servers

  12. Component Versions Found

  13. Database Engine Editions

  14. Components and Instances

  15. Server Information

  16. Adding Servers • Add Server Manually or With Stored Procedure

  17. Adding Servers - Details

  18. EPM – What Is That? • Enterprise Policy Management Framework • FREE from CodePlex (http://epmframework.codeplex.com/) • Reporting solution to extend 2008 PBM to all SQL Servers in your enterprise environment • SQL 2000, 2005, 2008

  19. Cool Reports

  20. Cool Reports – Details

  21. The Bottom

  22. DEMO

  23. Wrap Up • What is CMS • Things to Consider • Discovering Your Environment • Registering Multiple Servers • EPM

  24. Questions?

  25. Resources • MAP Tool (Microsoft Assessment and Planning) • http://technet.microsoft.com/en-us/library/bb977556.aspx • EPM Framework (CodePlex) • http://epmframework.codeplex.com/ • Cory Brown* • Premier Field Engineer , SQL Server, Microsoft

More Related