In that above screenshot, I connected to a CMS on P-SQL20081\CMS, and that instance stores the list of SQL Servers. From there, it’s basically the same as your local registered server list – only it’s centralized: Registered Servers window showing a CMS Right-click on Central Management Servers and you get options to set one up.
To configure it, open SSMS 2008 and go into the Registered Servers window. How to Set Up a Central Management Server When the DBA opens SQL Server Management Studio, they point at the CMS, and SSMS grabs the list of registered servers from there. With a CMS, the list of registered servers is stored on the central SQL Server. In a shop with two DBAs, they both have their own desktops (plus maybe laptops) and each machine has its own list of registered servers. Sounds simple – and it is – but it comes in handy, and it’s practically a requirement for a good policy-based management deployment. At my last company, we had a hard enough time telling everybody when we’d finished adding a new server, or what the new server’s name was, or when we didn’t need to look at a server anymore.Ī SQL Server CMS is just a central repository that holds a list of managed servers. This is useful for fast-changing shops where there’s a lot of servers added and removed.
Got more than one DBA? Want to make your life easier? You might want to configure a Central Management Server.
0 kommentar(er)
