Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2012-09-26 : 06:21:22
|
| 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.Thanks in advance.Thank You All In AdvanceKRS39 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-26 : 12:34:00
|
| I'm not sure I understand the isue. What symptoms are you experiencing?-Chad |
 |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-09-27 : 01:42:42
|
| 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.Thank You All In AdvanceKRS39 |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-28 : 01:47:44
|
| There could be a number of different reasons for high CPU. Some methods to analysea) Use the DMV – sys.dm_exec_query_stats by worker timeb) Check for high levels of recompilationsc)Consider redistributing database files onto other serversd) 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.htmlJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
High Physical Memory Utilization