The Management Pack for Microsoft SQL Server creates views that allow the user to view statistics of metrics for various Microsoft SQL Server resources. The views help give a broad picture of the entire system, as opposed to a more in depth view.
The following views are available in the Management Pack:
| View | Type | Description |
|---|---|---|
| MS SQL Queries | List | Lists all metrics on SQL Query resources |
| MS SQL Query Text | Text | SQL Query Text used for Query Analysis dashboard |
| MS SQL Server Database Disk Access | List | Lists Microsoft SQL Server Disk Access Activity |
| MS SQL Server Database Locks | List | Lists Disk Delays for Microsoft SQL Server Databases |
| MS SQL Server Database Overview | List | Lists performance and activity for Microsoft SQL Server Databases |
| MS SQL Server Database Size | List | Lists space usage breakdowns for Microsoft SQL Server Databases |
| MS SQL Server Disk Access | List | Lists Disk Activity information for Microsoft SQL Servers |
| MS SQL Server Locks | List | Lists lock and wait time information for Microsoft SQL Servers |
| MS SQL Server Memory Breakdown | List | Lists breakdown of Microsoft SQL Server Memory |
| MS SQL Server Overview | List | Provides overview list of Microsoft SQL Servers |
| MS SQL Server Size Distribution | Distribution | Provides distribution view of database sizes |
| MS SQL Server Stress | List | Lists stress breakdown of Microsoft SQL Servers |
To access the Management Pack views:
- Navigate to Environment > All Objects > Microsoft SQL Server .
- Double-click on the desired object (resource).
- Select the Details tab, then Views.
The available views for that resource are listed and can be selected.
Accessing Views
