JSON Path: Scans/sec')].cntr_value.first() If that is combined with high CPU, this counter requires further investigation, otherwise, if the full scans are on small tables, it can be ignored. Values greater than 1 or 2 indicate that there are table / index page scans. These can be either base-table or full-index scans. Number of unrestricted full scans per second. Number of records per second fetched through forwarded record pointers. The item gets server information about access methods. MS SQL Server uptime in 'N days, hh:mm:ss' format. Getting databases - database name and recovery model Set the username and password in host macros (] GRANT EXECUTE ON OBJECT::_datetime TO zbx_monitor įor more information, see MSSQL documentation:Ĭonfigure a User to Create and Manage SQL Server Agent Jobs
Grant this user read permissions to the sysjobschedules, sysjobhistory, sysjobs tables.įor example, using T-SQL commands: GRANT SELECT ON OBJECT:: TO zbx_monitor
View Server State and View Any Definition permissions should be granted to the user. Zabbix should be configured according to the instructions in the Templates out of the box section. This template is designed for the effortless deployment of MSSQL monitoring by Zabbix via ODBC and doesn't require any external scripts.
