Skip to main content
Version: 下一篇

Monitoring:SqlServer database monitoring

Collect and monitor the general performance indicators of SqlServer database. Support SqlServer 2017+.

Configuration parameter

Parameter nameParameter help description
Monitoring HostMonitored IPV4, IPV6 or domain name. Note⚠️Without protocol header (eg: https://, http://)
Monitoring nameIdentify the name of this monitoring. The name needs to be unique
PortPort provided by the database. The default is 1433
Query timeoutSet the timeout time when SQL query does not respond to data, unit: ms, default: 3000ms
Database nameDatabase instance name, optional
UsernameDatabase connection user name, optional
PasswordDatabase connection password, optional
URLDatabase connection URL,optional,If configured, the database name, user name, password and other parameters in the URL will overwrite the above configured parameters
Collection intervalInterval time of monitor periodic data collection, unit: second, and the minimum interval that can be set is 10 seconds
Whether to detectWhether to detect and check the availability of monitoring before adding monitoring. Adding and modifying operations will continue only after the detection is successful
Description remarksFor more information about identifying and describing this monitoring, users can note information here

Collection indicator

Indicator set:basic

Indicator nameIndicator unitIndicator help description
machine_namenoneWindows computer name running the server instance
server_namenoneServer and instance information SQL Server associated with Windows instance
versionnoneVersion of the instance,SQL Server,format is "major.minor.build.revision"
editionnoneThe product SQL server version of the installed instance
start_timenoneDatabase start time

Indicator set:performance_counters

Indicator nameIndicator unitIndicator help description
database_pagesnoneDatabase pages, Number of pages obtained (buffer pool)
target_pagesnoneTarget pages, The desired number of pages that the buffer pool must have
page_life_expectancysPage life expectancy. The time that data pages stay in the buffer pool. This time is generally greater than 300
buffer_cache_hit_ratio%Buffer cache hit ratio, Database buffer pool cache hit rate. The probability that the requested data is found in the buffer pool is generally greater than 80%, otherwise the buffer pool capacity may be too small
checkpoint_pages_secnoneCheckpoint pages/sec, The number of dirty pages written to the disk by the checkpoint per second. If the data is too high, it indicates that there is a lack of memory capacity
page_reads_secnonePage reads/sec, Number of pages read per second in the cache pool
page_writes_secnonePage writes/sec, Number of pages written per second in the cache pool

Indicator set:connection

Indicator nameIndicator unitIndicator help description
user_connectionnoneNumber of connected sessions