Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 High Physical Memory Utilization
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

193 Posts

Posted - 09/26/2012 :  06:21:22  Show Profile  Reply with Quote
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 Advance

The Chadinator

1974 Posts

Posted - 09/26/2012 :  12:34:00  Show Profile  Visit chadmat's Homepage  Reply with Quote
I'm not sure I understand the isue. What symptoms are you experiencing?

Go to Top of Page

Posting Yak Master

193 Posts

Posted - 09/27/2012 :  01:42:42  Show Profile  Reply with Quote
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 Advance
Go to Top of Page

Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 09/28/2012 :  01:47:44  Show Profile  Visit jackv's Homepage  Reply with Quote
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

Jack Vamvas
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000