MS SQL module
The root field containing all MSSQL fields
The database that the metrics is being referred to
Unique ID of the database inside MSSQL
Name of the database
performance metricset fetches information about the Performance Counters
Number of page splits per second that occur as the result of overflowing index pages.
Number of lock requests per second that required the caller to wait.
Total number of user connections
Total number of transactions
Number of temporary tables/table variables in use.
Total number of logins started from the connection pool.
Total number of logins started per second. This does not include pooled connections.
Total number of logout operations started per second.
Number of statement recompiles per second. Counts the number of times statement recompiles are triggered. Generally, you want the recompiles to be low.
Number of SQL compilations per second. Indicates the number of times the compile code path is entered. Includes compiles caused by statement-level recompilations in SQL Server. After SQL Server user activity is stable, this value reaches a steady state.
Number of Transact-SQL command batches received per second. This statistic is affected by all constraints (such as I/O, number of users, cache size, complexity of requests, and so on). High batch requests mean good throughput.
Indicates the percentage of pages found in the buffer cache without having to read from disk.
The ratio is the total number of cache hits divided by the total number of cache lookups over the last few thousand page accesses. After a long period of time, the ratio moves very little. Because reading from the cache is much less expensive than reading from disk, you want this ratio to be high
Indicates the number of seconds a page will stay in the buffer pool without references.
Indicates the number of seconds a page will stay in the buffer pool without references (in seconds).
Indicates the number of pages flushed to disk per second by a checkpoint or other operation that require all dirty pages to be flushed.
Indicates the number of pages in the buffer pool with database content.
Ideal number of pages in the buffer pool.
transaction_log metricset will fetch information about the operation and transaction log of each database from a MSSQL instance
Space usage information for the transaction log
The amount of space used since the last log backup
The amount of space used since the last log backup in bytes
The size of the log
The size of the log in bytes
The occupied size of the log
The occupied size of the log in bytes
A percentage of the occupied size of the log as a percent of the total log size
Returns summary level attributes and information on transaction log files of databases. Use this information for monitoring and diagnostics of transaction log health.
Total active transaction log size.
Total active transaction log size in bytes
Last transaction log backup time.
Log size since log recovery log sequence number (LSN).
Log size in bytes since log recovery log sequence number (LSN).
Log size since last checkpoint log sequence number (LSN).
Log size in bytes since last checkpoint log sequence number (LSN).
Total transaction log size.
Total transaction log size in bytes.