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
View Code

 

 

 

 

 

 

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

posted @ 2021-11-18 15:12  sam_wang10  阅读(22)  评论(0)  编辑  收藏  举报