Hi Experts, In one of my Prod server we are facing memory issue as the Virtual memory and Ram memory is utilized more and we are not able to find which is taking much. We are using SQL Server 2005 enterprise edition 64bit and the windows 2003 enterprise edition with a RAM about 32 GB and we have allotted 26GB of RAM memory SQL Severe as Max memory. We have allotted Virtual memory on two different drives each has 4 GB it’s on C: and D: drive. We are having a single database of 26GB and it’s a single dedicated database cluster server with no HA configured. Please let me know what I need to check and how to find and rectify the memory utilization.
Hi Chand, Thank you for the response, we are facing a CPU utilization of 100% and we can see that occasionally in the task manager where the spikes are high. And we find the Virtual Memory is utilized more and I saw it when I run SP_configure. Please let me know is there anything which can be configured to reduce the CPU utilization. Thank you in advance.
There could be a number of different reasons for high CPU. Some methods to analyse a) Use the DMV – sys.dm_exec_query_stats by worker time b) Check for high levels of recompilations c)Consider redistributing database files onto other servers d) Assess response from sys.dm_os_schedulers - find some code on http://www.sqlserver-dba.com/2011/04/sql-server-sos_scheduler_yield-and-how-to-reduce-it.html
High Physical Memory Utilization
Posted - 09/26/2012 : 06:21:22
