Page 2 of 2
Re: SQL Log Cache Hit Rate - type 'exceptions.ZeroDivisionEr
Posted: Tue Jan 05, 2016 4:27 pm
by lmiltchev
In addition to what rkennedy said, can you log in the mssql server as the user you are running the check with, select the database, run the following query, and show us a screenshot of the results?
Code: Select all
SELECT object_name, counter_name, instance_name, cntr_value, cntr_type
FROM sys.sysperfinfo
WHERE (counter_name = 'Log Cache Hit Ratio')
Re: SQL Log Cache Hit Rate - type 'exceptions.ZeroDivisionEr
Posted: Tue Jan 05, 2016 4:50 pm
by dlukinski
----------------------------------------------------------------------------------------------------------------------------------------------------------------
READONLY local account with "VIEW SERVER STATE ", "VIEW database STATE" and DB_datareader role to all DBs.
Password is not an issue (again ALL OTHER checks generated agaisnt the same Databases by the Wizard work).
Re: SQL Log Cache Hit Rate - type 'exceptions.ZeroDivisionEr
Posted: Tue Jan 05, 2016 5:04 pm
by tgriep
We tested this on out on a MSSQL 2008 server and the only way we could get it to work is to edit the user account and set it's Server Role as a sysadmin.
All of the other settings would not make this work. Can you try that and see if it resolves the issue?
Re: SQL Log Cache Hit Rate - type 'exceptions.ZeroDivisionEr
Posted: Wed Jan 06, 2016 10:23 am
by dlukinski
tgriep wrote:We tested this on out on a MSSQL 2008 server and the only way we could get it to work is to edit the user account and set it's Server Role as a sysadmin.
All of the other settings would not make this work. Can you try that and see if it resolves the issue?
Alright, we cannot do this in production for obvious reasons (therefore this has to be resolved by Nagios team, I think)
- we'll try finding/building test SQL to work with.
- one more question: should this be a local sysadmin account (no a domain, right)?
Re: SQL Log Cache Hit Rate - type 'exceptions.ZeroDivisionEr
Posted: Wed Jan 06, 2016 10:30 am
by lmiltchev
- one more question: should this be a local sysadmin account (no a domain, right)?
This is correct - you cannot use a domain user - it has to be a local account.
Do you mind if we lock this topic or you would like to keep it open for a while?
Re: SQL Log Cache Hit Rate - type 'exceptions.ZeroDivisionEr
Posted: Wed Jan 06, 2016 12:29 pm
by dlukinski
lmiltchev wrote:- one more question: should this be a local sysadmin account (no a domain, right)?
This is correct - you cannot use a domain user - it has to be a local account.
Do you mind if we lock this topic or you would like to keep it open for a while?
OK to lock.
Thank you once again
Re: SQL Log Cache Hit Rate - type 'exceptions.ZeroDivisionEr
Posted: Wed Jan 06, 2016 3:53 pm
by bwallace
Glad we were able to help. We'll lock this thread now and feel free to open another should you require assistance with anything else.