All of sudden cpu usage reaching 95 to 100% in my Production server 2005

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Dear Friends,

My production sql server suddenly reaching 100% usage of CPU that is for weekly twice or thrice that is only for 10 t0 20 minutes.
I have checked all thing from sql server level like,

Checking for blockings,
Checking for deadlocks,
Any slow running queries,
Before few hours also indexes are rebuilded,
checking for statistics etc etc .....

please suggest me any issues from application side.

But I am not able to understand, please give me any suggesions.

Regard's,
Thrilok,
SQL DBA.

Posted 10-Dec-14 0:33am

Thrilok SQL DBA

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

mudgilsks · Answer 1 · 2014-12-10T01:36:00

Solution 1

hi,

Use the two server memory options, min server memory and max server memory, to reconfigure the amount of memory (in megabytes) managed by the SQL Server Memory Manager for an instance of SQL Server.

In Object Explorer, right-click a server and select Properties.
Click the Memory node.
Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory.
You can also do it in T-SQL using the following commands (example):

exec sp_configure 'max server memory', 1024
reconfigure

for more
http://msdn.microsoft.com/en-us/library/ms178067.aspx[^]

Posted 10-Dec-14 1:36am

mudgilsks

Comments

Thrilok SQL DBA 11-Dec-14 0:11am

Dear Mud,

Thanks for your suggestion, but my doubt is, if that is the cause means i have to get the issue for every time but i am not getting every time only in particular time that is for only 10-20 mints twice or thrice in a week.

please suggest me.

Thank you.

mudgilsks 11-Dec-14 0:24am

Dear Thrilok ,

same issue was also with our Database Server.In starting we think it issue related to machine.We lock a issue compalian to the concern vander but no issue was their with machine.After that we lock issue complain to the Micro-soft Sql Server,they check the server,analysis the problem and in last was that sql server using the full CPU memory.they set the Limit for Sql Sqrver CPU utilization.after that our problem sol.

Try to find out How to set Limit For Sql Server.