Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

SQL Server 2008 R2 key changes: Multi-server management

See the new capabilities in SSMS that earned multi-server management a spot on our list of the top changes for SQL Server 2008 R2.


#3: Multi-server management

Multi-server management in SQL Server 2008 R2
(Image credit: Microsoft Corporation)

True, SQL Server Management Studio could always be used to manage multiple servers – just not from a single interface. Not anymore. SQL Server 2008 R2 features new SSMS dashboards for observing information on more than one server from the same screen by utilizing the new SQL Server Utility.

This new capability is the progression of SQL Server 2008's Data Collector where, once set up, DBAs can monitor resource utilization across their environments with a single glance.


1| 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11

NEXT >>  

This was last published in February 2010

Dig Deeper on Microsoft SQL Server 2008 R2

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.