Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Overview of SQL Server Utility

SQL Server customers have a requirement to manage their SQL Server environment as a whole, addressed in this release through the concept of application and multiserver management in the SQL Server Utility.

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

After SP2 has been applied, instances of the SQL Server 2008 Database Engine can be enrolled with a utility control point (UCP). However, you must use the SQL Server 2008 R2 client tools – SSMS - to monitor instances of SQL Server that are enrolled in a UCP. For more information, see Overview of SQL Server Utility in the Books Online for SQL Server 2008 R2.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.