SQL Server Performance

Performence counter in 2005

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by snarayanas, Dec 15, 2006.

  1. snarayanas New Member

    Hi all,

    I have noticed that buffer cache hit ratio on sql 2005 instance showing 0 values why?


    siri

    Swamy Sirigineedi
  2. gurucb New Member

    please check this output:
    select * from sysperfinfo

    Also check with

    perfmon /wmi and see what values are shown there..

    Is it only buffer cache hit ratio are all sql server counters are 0?

    What about registry and how did you end up with this situation.

  3. gurucb New Member

    Also check if SQL Server is not running in fiber mode and priority of SQL Server is normal.
    You can check that from Errorlog and sp_configure (light weight pooling)
  4. MohammedU New Member

    You check SYS.dm_os_performance_counters dmv too..


    Mohammed U.

Share This Page