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(tick)
Windows(tick)
OS X(tick)

 

To install the plugin

  1. From the top right of the screen, perform one of the following actions:
    • Click Settings > Data Collection, select the TrueSight meter, and select the Sources tab.

    • Click Settings > Configure Sources.
  2. 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.
  3. Click the name of the source to view source details.
  4. Select the Plugins tab.
  5. Use the search box or scroll through the page to find the plugin you want to install.
  6. 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 NameDescription
SourceThe 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.

Plugin metrics

Metric NameDescription
MSSQL_ACTIVE_TEMP_TABLESMSSQL - Active Temp Tables
MSSQL_USER_CONNECTIONSMSSQL - User Connections
MSSQL_LOGICAL_CONNECTIONSMSSQL - Logical Connections
MSSQL_TRANSACTIONSMSSQL - Transactions
MSSQL_PROCESSES_BLOCKEDMSSQL -processes blocked
MSSQL_LOCK_TIMEOUTSMSSQL - Lock Timeouts
MSSQL_LOCK_WAITSMSSQL - Lock Waits
MSSQL_LOCK_WAIT_TIME_MSMSSQL - Lock Wait Time (ms)
MSSQL_LOCK_AVERAGE_WAIT_TIME_MSMSSQL - Lock Average Wait Time (ms)
MSSQL_LOCK_TIMEOUTS_GT0MSSQL - Lock Timeouts (>0)
MSSQL_PERCENT_LOG_USEDMSSQL - % Log Used
MSSQL_REPL_PENDING_XACTSMSSQL - Replication Pending Transactions
MSSQL_COMPILATIONSMSSQL - sql compilations/sec
MSSQL_PAGE_IO_LATCH_WAITSMSSQL - IO Latch Waits
Was this page helpful? Yes No Submitting... Thank you

Comments