MSSQL fields
editMSSQL fields
editMS SQL module
mssql fields
editdatabase fields
editThe 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
editperformance 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
editIndicates 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
editIndicates 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
edittransaction_log metricset will fetch information about the operation and transaction log of each database from a MSSQL instance
space_usage fields
editSpace usage information for the transaction log
since_last_backup fields
editThe 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
editThe size of the log
-
mssql.transaction_log.space_usage.total.bytes
-
type: long
The size of the log in bytes
used fields
editThe 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
editReturns 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
editTotal 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
editLog 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
editLog 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
editTotal transaction log size.
-
mssql.transaction_log.stats.total_size.bytes
-
type: long
Total transaction log size in bytes.