October 15, 2009 at 1:42 pm
Hi all,
The total RAM is around 7.75 GB, but SQL server is consuming more than 5.5GB due to which CPU utilization is high.Can someone brief about this and throw some light on this.
Thank you!!!
October 15, 2009 at 3:16 pm
What is the max memory setting for that instance? Why do you think SQL Server using 5.5GB of memory out of 7.5GB (leaving 2GB to the OS which is fine), is causing your CPU issues?
Are there other applications running on this server that need memory?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 15, 2009 at 4:01 pm
sqlservr.exe is consuming the memory 5.5GB as per the task manager.
There are no other applications which requires the memory.Instance memory is by default 2147483647 B. If what you say is fine,then why CPU usage is indicating as high.
October 15, 2009 at 4:14 pm
What do you consider as high? If sql servers memory is not confined, the server will tend to take as much as it can. High CPU may be related to the data processing that server is doing. How many clients are connected? What types of queries are ran? If there are missing indexes, server will need more CPU and memory to scan tables.
Regards
Piotr
...and your only reply is slàinte mhath
October 16, 2009 at 6:38 am
SQL Server will manage it's own memory, so from the OS all you'll see is that SQL Server is using X, in this case 5gb. You can limit the amount that SQL Server uses, but the more is better. Still, I'd leave a gb or so for the OS.
To determine why the CPU is high, take a look at the wait states and queues on the system. One process using a lot of memory doesn't mean that that process is also using a lot of CPU (although it can too). Here's an article on how to use them. Also do a search on articles by Andrew Kelly. He's published some great stuff on the topic recently.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply