SQL Server Performance

Procedure Cache Hit Ratio Low

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by JuanBimba, Apr 7, 2009.

  1. JuanBimba New Member

    Hello,We are getting alerts raised by our monitoring system because the Procedure Cache Hit Ratio is quite low, below 75% in fact. The issue is that, I monitored the DB server, and realized that the misses are due to TDP, our backup solution and ironically NSM, our monitoring solution.We can lower the warning threshold of NSM, but is there any other way around this?TIARunning MS SQL server 2005 on windows 2003 SP2 x86
  2. satya Moderator

    Welcome to the forums.
    YOu must run PERFMON and capture counters for CPU, MEMORY, PHysical disk alongwith PROFILER and seperate any applications from SQL Server in order to keep it as a dedicated one for optimum performnace. If you perform update stats and reindex any number of times and due to the memory shortage sometime it is hard to get real time performance on server.
    What are the memory settings on SQL Server?
    Run sys.dm_os_memory_clerks and DBCC MEMORYSTATUS, post the results here.

Share This Page