Monitoring MSSQL DB

[MSPk]

Hi Team,

We are going to monitor MSSQL DB for one of our client using nagios, Client has policy not to give sysadmin access to any user on the production DB. Can you please suggest what kind of access is required for nagios user(admin access or normal read-only would do? which tables should the user have access to?, etc..) in order to get the performance metrics using the check_mssql_server.py and check_mssql_database.py plugin.

[slansing]

I believe at minimum it must be a user who can see and query what you are planning to check with the plugins, they should be able to sculpt a user to check specific tables, and metrics.