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.

  << PREVIOUS

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

NEXT >>  

This was first published in February 2010

Dig deeper on Microsoft SQL Server 2008 R2

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close