Stackstate-SQL Server Integration

Overview

Connect SQL Server to Stackstate in order to:

  • Visualize your database performance.
  • Correlate the performance of SQL Server with the rest of your applications.

For more details about configuring this integration refer to the following file(s) on GitHub:

Metrics

sqlserver.buffer.cache_hit_ratio
(gauge)
The ratio of data pages found and read from the buffer cache over all data page requests.
shown as fraction
sqlserver.buffer.page_life_expectancy
(gauge)
Duration that a page resides in the buffer pool.
shown as second
sqlserver.stats.batch_requests
(gauge)
The number of batch requests per second.
shown as request/second
sqlserver.stats.sql_compilations
(gauge)
The number of SQL compilations per second.
shown as operation/second
sqlserver.stats.sql_recompilations
(gauge)
The number of SQL re-compilations per second.
shown as operation/second
sqlserver.stats.connections
(gauge)
The number of user connections.
shown as connection
sqlserver.stats.lock_waits
(gauge)
The number of times per second that SQL Server is unable to retain a lock right away for a resource.
shown as lock/second
sqlserver.access.page_splits
(gauge)
The number of page splits per second.
shown as operation/second
sqlserver.stats.procs_blocked
(gauge)
The number of processes blocked.
shown as process
sqlserver.buffer.checkpoint_pages
(gauge)
The number of pages flushed to disk per second by a checkpoint or other operation that require all dirty pages to be flushed.
shown as page/second