Microsoft SQL Database Metrics
As a tenant administrator, editor, or viewer, you can use the Microsoft SQL Database Metrics dashboard to view the number of open events and various metrics of multiple SQL servers and devices from BMC Helix Operations Management. This information helps you to view the performance of Microsoft SQL databases and their metrics. This dashboard adds a new panel for each metric added from the filters.
The dashboard uses the BMC Helix data source and the Metric and Events query types.
Example: View the open events, disk, and memory usage of an SQL server
John, the tenant administrator, wants to view the number of open events, disk, and memory usage of an SQL server for a given period. He accesses the Microsoft SQL Database Metrics dashboard and selects the appropriate SQL server and metrics from filters to get the data for the previous day.
The following image shows the number of open events, disk, and memory usage of an SQL server with sample data:
To view the Microsoft SQL Database Metrics dashboard
- On the left navigation pane, hover over Dashboards
and click Browse. - Click the Operations Management folder and then click Microsoft SQL Database Metrics.
Tip
To quickly open the dashboard from the home page, mark it as a favorite by using the star icon. Additionally, after you open a dashboard, it is available under Recently viewed dashboards on the home page.
Panels in the Microsoft SQL Database Metrics dashboard
| Panel | Description | Example |
|---|---|---|
| Device Name | Select one or multiple devices from this list to view their metrics data. |
|
| Metric Name | Select the required metrics from this list to view data for them. The data for each metric will be displayed as an individual panel in the dashboard. |
|
| Open Events | View the number of open events on the devices that you selected for a given period. |
|
Comments
Log in or register to comment.