question

vivekchandra09 avatar image
vivekchandra09 asked

MSSQL Log Cache Hit Rate is CRITICAL

I have been getting this error for more than 24 hour: MSSQL Log Cache Hit Rate is CRITICAL. CRITICAL: Log Cache Hit Ratio is 98.1173246727% what should I do to fix this issue.
mssqllogcache
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Phil Factor avatar image Phil Factor commented ·
You need to tell use where this error is coming from. It doesn't seem like a SQL Server error to me. Is this from a nagios server?
1 Like 1 ·
vivekchandra09 avatar image vivekchandra09 commented ·
this is from nagios server.
0 Likes 0 ·

1 Answer

·
Phil Factor avatar image
Phil Factor answered
This is not likely to be a SQL Server problem but more likely a problem with the Nagios module. The best reference is here https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-buffer-cache-hit-ratio/ . Sure you could have a problem with the SQL server but read the link I've given you carefully first before considering that..
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.