Post reply

How To Obtain "Buffer Cache Hit Ratio" and "Page Life Expectancy"?

  • March 20, 2010 at 7:16 am

    #212846

    I'm working on a client's server running Windows Server 2003 Standard Edition and SQL Server 2005 Standard Edition. The underlying server is a 64 bit machine. The version of SQL Server installed is the 32 bit version.

    I need to analyze some critical metrics of SQL Server performance. There are none available in the Performance Monitor interface.

    Is there a SQL query or some other way to obtain "Buffer Cache Hit Ratio", "Page Life Expectancy", and "Number of Connections?

    Thanks,

    LC

  • March 20, 2010 at 7:28 am

    #1137172

    I just found it in Books Online.

    This query will provide them: "SELECT * FROM sys.dm_os_performance_counters".

    LC

  • March 22, 2010 at 6:34 am

    #1137536

    It's good that you can use the DMV to satisfy your need, but you should be able to see it in Performance Monitor too. It can be a common problem that the perfmon counters for SQL Server get... lost. There's an article on MSDN on how to restore them.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • March 22, 2010 at 6:56 am

    #1137553

    Thanks, Grant.

    LC

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

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