zb monitoring mssql

 

 

vim /etc/odbcinst.ini

 

 

 

创建监控账号

use master
EXEC sp_addlogin 'zbx_monitor', 'Pas5W@0rd', 'master' 

USE [master]
GO
GRANT VIEW ANY DATABASE TO [zbx_monitor]

EXEC sp_MSforeachdb 'use[*] CREATE USER [zbx_monitor] FOR LOGIN [zbx_monitor]',@replacechar = '*'

USE [master]
GO
GRANT VIEW SERVER STATE TO [zbx_monitor]


USE [master]
GO
GRANT VIEW ANY DEFINITION TO [zbx_monitor]
GO

use [master]
GRANT select ON sys.dm_hadr_availability_group_states to zbx_monitor 
GRANT select ON sys.dm_os_sys_memory to zbx_monitor 
GRANT select ON sys.dm_os_performance_counters to zbx_monitor 
GRANT select ON sysperfinfo to zbx_monitor

 

 

 

 

 

 

https://www.zabbix.com/integrations/mssql