SQL Log Cache Hit Rate - type 'exceptions.ZeroDivisionError

[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')

[dlukinski]

What are the rights that are granted to the user account on the MSSQl server?

Do you have an answer to this?

Also - does your password contain any special characters? Are you using domain\username to login or just username?

See this links for a bit more info -
https://support.microsoft.com/en-us/kb/555332
http://stackoverflow.com/questions/3583 ... sql-server

----------------------------------------------------------------------------------------------------------------------------------------------------------------

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).

[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?

[dlukinski]

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)?

[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?

[dlukinski]

- 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

[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.