- Metricbeat Reference: other versions:
- Overview
- Getting started with Metricbeat
- Setting up and running Metricbeat
- Upgrading Metricbeat
- How Metricbeat works
- Configuring Metricbeat
- Specify which modules to run
- Specify general settings
- Load external configuration files
- Configure the internal queue
- Configure the output
- Configure index lifecycle management
- Specify SSL settings
- Filter and enhance the exported data
- Define processors
- Add cloud metadata
- Add fields
- Add labels
- Add the local time zone
- Add tags
- Decode JSON fields
- Decode Base64 fields
- Decompress gzip fields
- Community ID Network Flow Hash
- Convert
- Drop events
- Drop fields from events
- Extract array
- Keep fields from events
- Registered Domain
- Rename fields from events
- Add Kubernetes metadata
- Add Docker metadata
- Add Host metadata
- Add Observer metadata
- Dissect strings
- DNS Reverse Lookup
- Add process metadata
- Parse data by using ingest node
- Enrich events with geoIP information
- Configure project paths
- Configure the Kibana endpoint
- Load the Kibana dashboards
- Load the Elasticsearch index template
- Configure logging
- Use environment variables in the configuration
- Autodiscover
- YAML tips and gotchas
- Regular expression support
- HTTP Endpoint
- metricbeat.reference.yml
- Beats central management
- Modules
- Aerospike module
- Apache module
- aws module
- Beat module
- Ceph module
- CockroachDB module
- consul module
- coredns module
- Couchbase module
- couchdb module
- Docker module
- Dropwizard module
- Elasticsearch module
- Elasticsearch ccr metricset
- Elasticsearch cluster_stats metricset
- Elasticsearch index metricset
- Elasticsearch index_recovery metricset
- Elasticsearch index_summary metricset
- Elasticsearch ml_job metricset
- Elasticsearch node metricset
- Elasticsearch node_stats metricset
- Elasticsearch pending_tasks metricset
- Elasticsearch shard metricset
- envoyproxy module
- Etcd module
- Golang module
- Graphite module
- HAProxy module
- HTTP module
- Jolokia module
- Kafka module
- Kibana module
- Kubernetes module
- Kubernetes apiserver metricset
- Kubernetes container metricset
- Kubernetes controllermanager metricset
- Kubernetes event metricset
- Kubernetes node metricset
- Kubernetes pod metricset
- Kubernetes proxy metricset
- Kubernetes scheduler metricset
- Kubernetes state_container metricset
- Kubernetes state_cronjob metricset
- Kubernetes state_deployment metricset
- Kubernetes state_node metricset
- Kubernetes state_pod metricset
- Kubernetes state_replicaset metricset
- Kubernetes state_statefulset metricset
- Kubernetes system metricset
- Kubernetes volume metricset
- kvm module
- Logstash module
- Memcached module
- MongoDB module
- MSSQL module
- Munin module
- MySQL module
- Nats module
- Nginx module
- Oracle module
- PHP_FPM module
- PostgreSQL module
- Prometheus module
- RabbitMQ module
- Redis module
- Statsd module
- System module
- System core metricset
- System cpu metricset
- System diskio metricset
- System entropy metricset
- System filesystem metricset
- System fsstat metricset
- System load metricset
- System memory metricset
- System network metricset
- System process metricset
- System process_summary metricset
- System raid metricset
- System socket metricset
- System socket_summary metricset
- System uptime metricset
- traefik module
- uwsgi module
- vSphere module
- Windows module
- ZooKeeper module
- Exported fields
- Aerospike fields
- Apache fields
- aws fields
- Beat fields
- Beat fields
- Ceph fields
- Cloud provider metadata fields
- CockroachDB fields
- Common fields
- consul fields
- coredns fields
- Couchbase fields
- couchdb fields
- Docker fields
- Docker fields
- Dropwizard fields
- ECS fields
- Elasticsearch fields
- envoyproxy fields
- Etcd fields
- Golang fields
- Graphite fields
- HAProxy fields
- Host fields
- HTTP fields
- Jolokia fields
- Jolokia Discovery autodiscover provider fields
- Kafka fields
- Kibana fields
- Kubernetes fields
- Kubernetes fields
- kvm fields
- Logstash fields
- Memcached fields
- MongoDB fields
- MSSQL fields
- Munin fields
- MySQL fields
- Nats fields
- Nginx fields
- Oracle fields
- PHP_FPM fields
- PostgreSQL fields
- Process fields
- Prometheus fields
- RabbitMQ fields
- Redis fields
- Statsd fields
- System fields
- traefik fields
- uwsgi fields
- vSphere fields
- Windows fields
- ZooKeeper fields
- Monitoring Metricbeat
- Securing Metricbeat
- Troubleshooting
- Get help
- Debug
- Common problems
- "open /compat/linux/proc: no such file or directory" error on FreeBSD
- Metricbeat collects system metrics for interfaces you didn’t configure
- Metricbeat uses too much bandwidth
- Error loading config file
- Found unexpected or unknown characters
- Logstash connection doesn’t work
- @metadata is missing in Logstash
- Not sure whether to use Logstash or Beats
- SSL client fails to connect to Logstash
- Monitoring UI shows fewer Beats than expected
- Contributing to Beats
MSSQL fields
editMSSQL fields
editMS SQL module
mssql
editThe root field containing all MSSQL fields
database
editThe database that the metrics is being referred to
-
mssql.database.id -
Unique ID of the database inside MSSQL
type: long
-
mssql.database.name -
Name of the database
type: keyword
performance
editperformance metricset fetches information about the Performance Counters
-
mssql.performance.page_splits_per_sec -
Number of page splits per second that occur as the result of overflowing index pages.
type: long
-
mssql.performance.lock_waits_per_sec -
Number of lock requests per second that required the caller to wait.
type: long
-
mssql.performance.user_connections -
Total number of user connections
type: long
-
mssql.performance.transactions -
Total number of transactions
type: long
-
mssql.performance.active_temp_tables -
Number of temporary tables/table variables in use.
type: long
-
mssql.performance.connections_reset_per_sec -
Total number of logins started from the connection pool.
type: long
-
mssql.performance.logins_per_sec -
Total number of logins started per second. This does not include pooled connections.
type: long
-
mssql.performance.logouts_per_sec -
Total number of logout operations started per second.
type: long
-
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
-
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
-
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
cache_hit
editIndicates the percentage of pages found in the buffer cache without having to read from disk.
-
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
page_life_expectancy
editIndicates the number of seconds a page will stay in the buffer pool without references.
-
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
-
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
-
mssql.performance.buffer.database_pages -
Indicates the number of pages in the buffer pool with database content.
type: long
-
mssql.performance.buffer.target_pages -
Ideal number of pages in the buffer pool.
type: long
transaction_log
edittransaction_log metricset will fetch information about the operation and transaction log of each database from a MSSQL instance
space_usage
editSpace usage information for the transaction log
since_last_backup
editThe amount of space used since the last log backup
-
mssql.transaction_log.space_usage.since_last_backup.bytes -
The amount of space used since the last log backup in bytes
type: long
total
editThe size of the log
-
mssql.transaction_log.space_usage.total.bytes -
The size of the log in bytes
type: long
used
editThe occupied size of the log
-
mssql.transaction_log.space_usage.used.bytes -
The occupied size of the log in bytes
type: long
-
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
stats
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
editTotal active transaction log size.
-
mssql.transaction_log.stats.active_size.bytes -
Total active transaction log size in bytes
type: long
-
mssql.transaction_log.stats.backup_time -
Last transaction log backup time.
type: date
recovery_size
editLog size since log recovery log sequence number (LSN).
-
mssql.transaction_log.stats.recovery_size.bytes -
Log size in bytes since log recovery log sequence number (LSN).
type: long
since_last_checkpoint
editLog size since last checkpoint log sequence number (LSN).
-
mssql.transaction_log.stats.since_last_checkpoint.bytes -
Log size in bytes since last checkpoint log sequence number (LSN).
type: long
total_size
editTotal transaction log size.
-
mssql.transaction_log.stats.total_size.bytes -
Total transaction log size in bytes.
type: long
On this page