SQL Server 2008 R2 introduced SQL Server utility as the center of operations to consolidate and to monitor the managed instances of SQL Server. Launch the utility explorer from the View option in the Menu in SSMS.
The SQL Server Utility models an organization’s SQL Server-related entities in a unified view. Utility Explorer and SQL Server Utility viewpoints in (SSMS) provide administrators a holistic view of resource health through an instance of SQL Server that serves as a utility control point (UCP). Entities that can be viewed in the SQL Server UCP include:
- Instances of SQL Server
- Data-tier applications
- Database files
- Storage volumes
Resource utilization dimensions that can be viewed in the SQL Server UCP include:
- CPU utilization
- Storage space utilization
SQL Server Utility Demo by MVP Brent Ozar – http://sqlserverpedia.com/blog/sql-server-2008/sql-server-2008-r2-utility-demo/
How To” topics on SQL Server Utility http://msdn.microsoft.com/en-us/library/ee210564(v=SQL.105).aspx
