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.
| Linux |  |
| Windows | |
| OS X | |
To install the plugin
- 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.
Configuration details
| 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 |
Plugin metrics
| 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 |
Was this page helpful? Yes No
Submitting...
Thank you
Comments