MS SQL Server
MS SQL Server
Plugin: windows.plugin Module: PerflibMSSQL
Overview
This collector monitors Microsoft SQL Server statistics.
It queries different SQL objects per instance from Perflib in order to gather the metrics.
This collector is only supported on the following platforms:
- windows
This collector only supports collecting metrics from a single instance of this integration.
Default Behavior
Auto-Detection
The collector automatically detects all of the metrics, no further configuration is required.
Limits
The default configuration for this integration does not impose any limits on data collection.
Performance Impact
The default configuration for this integration is not expected to impose a significant performance impact on the system.
Setup
Prerequisites
No action required.
Configuration
File
The configuration file name for this integration is netdata.conf.
Configuration for this specific integration is located in the [plugin:windows] section within that file.
The file format is a modified INI syntax. The general structure is:
[section1]
option1 = some value
option2 = some other value
[section2]
option3 = some third value
You can edit the configuration file using the edit-config script from the
Netdata config directory.
cd /etc/netdata 2>/dev/null || cd /opt/netdata/etc/netdata
sudo ./edit-config netdata.conf
Options
| Name | Description | Default | Required |
|---|---|---|---|
| PerflibMSSQL | An option to enable or disable the data collection. | yes | no |
Examples
There are no configuration examples.
Metrics
Metrics grouped by scope.
The scope defines the instance that the metric belongs to. An instance is uniquely identified by a set of labels.
Per MSSQL instance
These metrics refer to the Microsoft SQL Servers instances defined on host.
Labels:
| Label | Description |
|---|---|
| mssql_instance | The instance name. |
Metrics:
| Metric | Dimensions | Unit |
|---|---|---|
| mssql.instance_user_connections | user | connections |
| mssql.instance_sqlstats_batch_requests | batch | requests/s |
| mssql.instance_sql_errors | errors | errors/s |
| mssql.instance_sqlstats_sql_compilations | compilations | compilations/s |
| mssql.instance_sqlstats_sql_recompilations | recompiles | recompiles/s |
| mssql.instance_sqlstats_auto_parameterization_attempts | failed | attempts/s |
| mssql.instance_sqlstats_safe_auto_parameterization_attempts | safe | attempts/s |
| mssql.instance_accessmethods_page_splits | page | splits/s |
| mssql.instance_cache_hit_ratio | hit_ratio | percentage |
| mssql.instance_bufman_iops | read, written | pages/s |
| mssql.instance_bufman_checkpoint_pages | log | pages/s |
| mssql.instance_bufman_page_life_expectancy | life_expectancy | seconds |
| mssql.instance_memmgr_server_memory | memory | bytes |
| mssql.instance_memmgr_connection_memory_bytes | memory | bytes |
| mssql.instance_memmgr_pending_memory_grants | pending | processes |
| mssql.instance_memmgr_external_benefit_of_memory | benefit | bytes |
| mssql.instance_locks_deadlocks | alloc_unit, application, database, extent, file, hobt, key, metadata, oib, object, page, rid, row_group, xact | deadlocks/s |
| mssql.instance_locks_lock_wait | alloc_unit, application, database, extent, file, hobt, key, metadata, oib, object, page, rid, row_group, xact | locks/s |
| mssql.instance_blocked_processes | blocked | processes |
Per Database
These metrics refer to Microsoft SQL Server databases.
Labels:
| Label | Description |
|---|---|
| mssql_instance | The instance name. |
| database | The database name. |
Metrics:
| Metric | Dimensions | Unit |
|---|---|---|
| mssql.database_active_transactions | active | transactions |
| mssql.database_transactions | transactions | transactions/s |
| mssql.database_write_transactions | write | transactions/s |
| mssql.database_backup_restore_operations | backup | operations/s |
| mssql.database_log_flushes | log | flushes/s |
| mssql.database_log_flushed | flushed | bytes/s |
Alerts
There are no alerts configured by default for this integration.