﻿---
title: MSSQL fields
description: MS SQL module The root field containing all MSSQL fields The database that the metrics is being referred to performance metricset fetches information...
url: https://www.elastic.co/elastic/docs-builder/docs/2771/reference/beats/metricbeat/exported-fields-mssql
products:
  - Beats
  - Metricbeat
applies_to:
  - Elastic Cloud Serverless: Generally available
  - Elastic Stack: Generally available
---

# MSSQL fields
MS SQL module

## mssql

The root field containing all MSSQL fields

## database

The database that the metrics is being referred to
<definitions>
  <definition term="mssql.database.id">
    Unique ID of the database inside MSSQL
    type: long
  </definition>
  <definition term="mssql.database.name">
    Name of the database
    type: keyword
  </definition>
</definitions>


## performance

performance metricset fetches information about the Performance Counters
<definitions>
  <definition term="mssql.performance.page_splits_per_sec">
    Number of page splits per second that occur as the result of overflowing index pages.
    type: long
  </definition>
  <definition term="mssql.performance.lock_waits_per_sec">
    Number of lock requests per second that required the caller to wait.
    type: long
  </definition>
  <definition term="mssql.performance.user_connections">
    Total number of user connections
    type: long
  </definition>
  <definition term="mssql.performance.transactions">
    Total number of transactions
    type: long
  </definition>
  <definition term="mssql.performance.active_temp_tables">
    Number of temporary tables/table variables in use.
    type: long
  </definition>
  <definition term="mssql.performance.connections_reset_per_sec">
    Total number of logins started from the connection pool.
    type: long
  </definition>
  <definition term="mssql.performance.logins_per_sec">
    Total number of logins started per second. This does not include pooled connections.
    type: long
  </definition>
  <definition term="mssql.performance.logouts_per_sec">
    Total number of logout operations started per second.
    type: long
  </definition>
  <definition term="mssql.performance.recompilations_per_sec">
    Number of statement recompiles per second. Counts the number of times statement recompiles are triggered. Generally, you want the recompiles to be low.
    type: long
  </definition>
  <definition term="mssql.performance.compilations_per_sec">
    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.
    type: long
  </definition>
  <definition term="mssql.performance.batch_requests_per_sec">
    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.
    type: long
  </definition>
</definitions>


## cache_hit

Indicates the percentage of pages found in the buffer cache without having to read from disk.
<definitions>
  <definition term="mssql.performance.buffer.cache_hit.pct">
    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
    type: double
  </definition>
</definitions>


## page_life_expectancy

Indicates the number of seconds a page will stay in the buffer pool without references.
<definitions>
  <definition term="mssql.performance.buffer.page_life_expectancy.sec">
    Indicates the number of seconds a page will stay in the buffer pool without references (in seconds).
    type: long
  </definition>
  <definition term="mssql.performance.buffer.checkpoint_pages_per_sec">
    Indicates the number of pages flushed to disk per second by a checkpoint or other operation that require all dirty pages to be flushed.
    type: long
  </definition>
  <definition term="mssql.performance.buffer.database_pages">
    Indicates the number of pages in the buffer pool with database content.
    type: long
  </definition>
  <definition term="mssql.performance.buffer.target_pages">
    Ideal number of pages in the buffer pool.
    type: long
  </definition>
</definitions>


## transaction_log

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

## space_usage

Space usage information for the transaction log

## since_last_backup

The amount of space used since the last log backup
<definitions>
  <definition term="mssql.transaction_log.space_usage.since_last_backup.bytes">
    The amount of space used since the last log backup in bytes
    type: long
  </definition>
</definitions>


## total

The size of the log
<definitions>
  <definition term="mssql.transaction_log.space_usage.total.bytes">
    The size of the log in bytes
    type: long
  </definition>
</definitions>


## used

The occupied size of the log
<definitions>
  <definition term="mssql.transaction_log.space_usage.used.bytes">
    The occupied size of the log in bytes
    type: long
  </definition>
  <definition term="mssql.transaction_log.space_usage.used.pct">
    A percentage of the occupied size of the log as a percent of the total log size
    type: float
  </definition>
</definitions>


## stats

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

Total active transaction log size.
<definitions>
  <definition term="mssql.transaction_log.stats.active_size.bytes">
    Total active transaction log size in bytes
    type: long
  </definition>
  <definition term="mssql.transaction_log.stats.backup_time">
    Last transaction log backup time.
    type: date
  </definition>
</definitions>


## recovery_size

Log size since log recovery log sequence number (LSN).
<definitions>
  <definition term="mssql.transaction_log.stats.recovery_size.bytes">
    Log size in bytes since log recovery log sequence number (LSN).
    type: long
  </definition>
</definitions>


## since_last_checkpoint

Log size since last checkpoint log sequence number (LSN).
<definitions>
  <definition term="mssql.transaction_log.stats.since_last_checkpoint.bytes">
    Log size in bytes since last checkpoint log sequence number (LSN).
    type: long
  </definition>
</definitions>


## total_size

Total transaction log size.
<definitions>
  <definition term="mssql.transaction_log.stats.total_size.bytes">
    Total transaction log size in bytes.
    type: long
  </definition>
</definitions>