MSSQL fields

edit

MS SQL module

mssql fields

edit

database fields

edit

The database that the metrics is being referred to

mssql.database.id

type: long

Unique ID of the database inside MSSQL

mssql.database.name

type: keyword

Name of the database

performance fields

edit

performance metricset fetches information about the Performance Counters

mssql.performance.page_splits_per_sec

type: long

Number of page splits per second that occur as the result of overflowing index pages.

mssql.performance.lock_waits_per_sec

type: long

Number of lock requests per second that required the caller to wait.

mssql.performance.user_connections

type: long

Total number of user connections

mssql.performance.transactions

type: long

Total number of transactions

mssql.performance.active_temp_tables

type: long

Number of temporary tables/table variables in use.

mssql.performance.connections_reset_per_sec

type: long

Total number of logins started from the connection pool.

mssql.performance.logins_per_sec

type: long

Total number of logins started per second. This does not include pooled connections.

mssql.performance.logouts_per_sec

type: long

Total number of logout operations started per second.

mssql.performance.recompilations_per_sec

type: long

Number of statement recompiles per second. Counts the number of times statement recompiles are triggered. Generally, you want the recompiles to be low.

mssql.performance.compilations_per_sec

type: long

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.

mssql.performance.batch_requests_per_sec

type: long

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.

cache_hit fields

edit

Indicates the percentage of pages found in the buffer cache without having to read from disk.

mssql.performance.buffer.cache_hit.pct

type: double

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

page_life_expectancy fields

edit

Indicates the number of seconds a page will stay in the buffer pool without references.

mssql.performance.buffer.page_life_expectancy.sec

type: long

Indicates the number of seconds a page will stay in the buffer pool without references (in seconds).

mssql.performance.buffer.checkpoint_pages_per_sec

type: long

Indicates the number of pages flushed to disk per second by a checkpoint or other operation that require all dirty pages to be flushed.

mssql.performance.buffer.database_pages

type: long

Indicates the number of pages in the buffer pool with database content.

mssql.performance.buffer.target_pages

type: long

Ideal number of pages in the buffer pool.

transaction_log fields

edit

transaction_log metricset will fetch information about the operation and transaction log of each database from a MSSQL instance

space_usage fields

edit

Space usage information for the transaction log

since_last_backup fields

edit

The amount of space used since the last log backup

mssql.transaction_log.space_usage.since_last_backup.bytes

type: long

The amount of space used since the last log backup in bytes

total fields

edit

The size of the log

mssql.transaction_log.space_usage.total.bytes

type: long

The size of the log in bytes

used fields

edit

The occupied size of the log

mssql.transaction_log.space_usage.used.bytes

type: long

The occupied size of the log in bytes

mssql.transaction_log.space_usage.used.pct

type: float

A percentage of the occupied size of the log as a percent of the total log size

stats fields

edit

Returns summary level attributes and information on transaction log files of databases. Use this information for monitoring and diagnostics of transaction log health.

active_size fields

edit

Total active transaction log size.

mssql.transaction_log.stats.active_size.bytes

type: long

Total active transaction log size in bytes

mssql.transaction_log.stats.backup_time

type: date

Last transaction log backup time.

recovery_size fields

edit

Log size since log recovery log sequence number (LSN).

mssql.transaction_log.stats.recovery_size.bytes

type: long

Log size in bytes since log recovery log sequence number (LSN).

since_last_checkpoint fields

edit

Log size since last checkpoint log sequence number (LSN).

mssql.transaction_log.stats.since_last_checkpoint.bytes

type: long

Log size in bytes since last checkpoint log sequence number (LSN).

total_size fields

edit

Total transaction log size.

mssql.transaction_log.stats.total_size.bytes

type: long

Total transaction log size in bytes.