Follow

Microsoft SQL Server Plugin

The meter plugin Collects metrics from Microsoft SQL Server instance using a subset of the SQL Server Performance Counters from WMI. This plugin supports multiple SQL Server instances running on the same machine. Each instance is displayed as a separate source on your TrueSight Pulse dashboard.

Prerequisites
  • Supported OS: Windows
  • TrueSight Pulse meter 4.2 or later
  • SQL Server: 2008, 2012, 2014 or 2016
To install new meter go to 'Settings-> Installation' or see instructions.
To upgrade the meter to the latest version see instructions
 
Metrics Collected:
  • MSSQL_ACTIVE_TEMP_TABLES
  • MSSQL_USER_CONNECTIONS
  • MSSQL_LOGICAL_CONNECTIONS
  • MSSQL_TRANSACTIONS
  • MSSQL_PROCESSES_BLOCKED
  • MSSQL_LOCK_TIMEOUTS
  • MSSQL_LOCK_WAITS
  • MSSQL_LOCK_WAIT_TIME_MS
  • MSSQL_LOCK_AVERAGE_WAIT_TIME_MS
  • MSSQL_LOCK_TIMEOUTS_GT0
  • MSSQL_PERCENT_LOG_USED
  • MSSQL_REPL_PENDING_XACTS
  • MSSQL_COMPILATIONS
  • MSSQL_PAGE_IO_LATCH_WAITS
Installing the plugin
 
1) Log into the BMC TrueSight Pulse console.
 
2) Go to Settings > Plugins
 
3) Click 'Get Plugins'.
 
4) Scroll to 'mssql' and click 'Install'.
 
5) Pulse provides a list of meters to associate to the plugin.  Select a meter.  Now an "Add a plugin..." drop down box will display.
 
Field Name Description
Source The source to display in the legend for the data
Poll Interval (ms) The interval (in milliseconds) to poll for metrics
 
6) Type the required details, use the available tool-tips for help.  Click "OK".
 
7) The following dashboard will be created:
  • MSSQL
Have more questions? Submit a request