Post reply

sql sever cache mgr error

  • November 29, 2007 at 7:50 pm

    #181828

    A client of mine sent me this saying they were seeing it on there sql server.

    I could not find a hard answer as to what to do other than check memory usage etc.

    How else can i evaluate this issue??

    Performance Counter Alert :: Performance - SQL Server Remote Control

    Category: SQLServer:Cache Manager Instance: _Total Counter: Cache Hit Ratio

    Threshold: 80 Number of data points: 1 Direction:

    Thanks

  • December 3, 2007 at 9:56 am

    #756558

    Not sure if I interpreted the message correctly but it seems like they are having a low cache hit ratio, which is generally indicative of either too little memory or poorly written/indexed queries - or both.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply