Microsoft SQL Server plugin

This 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.

Prerequisites

Meter version 4.2 or later must be installed.

The Microsoft SQL Server plugin (2008, 2012, 2014, or 2016) supports the following Operating Systems.

From the top right of the screen, perform one of the following actions:
- Click > Data Collection, select the TrueSight meter, and select the Sources tab.
- Click > Configure Sources.
Use the search box or scroll through the page to find the source system which has the TrueSight meter on which you want to install the plugin.
Click the name of the source to view source details.
Select the Plugins tab.
Use the search box or scroll through the page to find the plugin you want to install.
Click + Install to start the installation.
Refer to the following sections for the configuration details required to collect data and view the list of plugin metrics.

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

Advanced configuration

To customize this plugin, see MSSQL plugin on GitHub.

Metric Name	Description
MSSQL_ACTIVE_TEMP_TABLES	MSSQL - Active Temp Tables
MSSQL_USER_CONNECTIONS	MSSQL - User Connections
MSSQL_LOGICAL_CONNECTIONS	MSSQL - Logical Connections
MSSQL_TRANSACTIONS	MSSQL - Transactions
MSSQL_PROCESSES_BLOCKED	MSSQL -processes blocked
MSSQL_LOCK_TIMEOUTS	MSSQL - Lock Timeouts
MSSQL_LOCK_WAITS	MSSQL - Lock Waits
MSSQL_LOCK_WAIT_TIME_MS	MSSQL - Lock Wait Time (ms)
MSSQL_LOCK_AVERAGE_WAIT_TIME_MS	MSSQL - Lock Average Wait Time (ms)
MSSQL_LOCK_TIMEOUTS_GT0	MSSQL - Lock Timeouts (>0)
MSSQL_PERCENT_LOG_USED	MSSQL - % Log Used
MSSQL_REPL_PENDING_XACTS	MSSQL - Replication Pending Transactions
MSSQL_COMPILATIONS	MSSQL - sql compilations/sec
MSSQL_PAGE_IO_LATCH_WAITS	MSSQL - IO Latch Waits