SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

ksr39
Posting Yak Master

India
179 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
KRS39

chadmat
The Chadinator

USA
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?

-Chad
Go to Top of Page

ksr39
Posting Yak Master

India
179 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
KRS39
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2019 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 http://www.sqlserver-dba.com/2011/04/sql-server-sos_scheduler_yield-and-how-to-reduce-it.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.06 seconds. Powered By: Snitz Forums 2000