Post reply

SQLH2 Performance Collector - Buffer Cache Hit Ratio Problem

  • January 31, 2007 at 1:43 am

    #115434

    Hi All

     

    I am having the following problem with the SQLH2 Performance Collector.

     

    I am running the SQLH2 Performance Collector against both SQL 2000 and SQL 2005

    servers. Data for the 'SQLServer: Buffer Manager | Buffer Cache Hit Ratio' counter is being collected successfully from the SQL 2000 servers, but not from the SQL

    2005 Servers. The only value recorded for the 2005 servers is always a 0.

     

    There are no errors in the Event Viewer for the Performance Collector.

     

    Any suggestions or experience with this problem would be appreciated.

     

    Regards

    Stevo

  • February 1, 2007 at 8:08 pm

    #687298

    Apparently it is a known bug with the 1.1 .NET Framework. More here:

    MSDN Forums - Reply from Microsoft

     

    K. Brian Kelley
    @kbriankelley

  • February 1, 2007 at 11:17 pm

    #687313

    Hi All

     

    Just to close of this thread.  As Brian indicated this is a know bug and according to Microsoft they will not be fixing it anytime soon.  Your best bet in this situation is to simply use some of the other memory performance counters.

     

    Thanks to everybody for your feedback especially the guys from Microsoft who responded to my query.

     

    Stevo

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

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