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.

Related topics

Roles-and-permissions

Configuring-dashboards-panels-and-queries

Setting-up-dashboards


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:

SQLDatabaseMetricsMainScreen.png


To view the Microsoft SQL Database Metrics dashboard

  1. On the left navigation pane, hover over Dashboards dashboard_icon_dec_push.png and click Browse.
  2. 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