Server is very slow

Question

Server is very slow

RPSQL

Hall of Fame

Points: 3229
More actions
September 2, 2008 at 8:59 am

#197725

One of our sql server is very slow...
I tried perf mon on our system for 3 consecutive days and find these values high.
Average disk que length is high – 3( three days average)
PhysicalDisk(1 D:)\% Disk Time – is above 200 %
Processor(0)\% Processor Time- is above 55 %
Can anyone have idea that How can I go ahead?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

I'd start by finding out what queries are slow, then find out why. More often than not, that's the problem. Run a trace if you don't know which ones to start with.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

CrazyMan SSChampion Points: 12560 More actions · Answer 2

Hi RP

Try to check if there are any changes that have been made on the server and any new process has been included, often this might cause problems

🙂

KDASQL Ten Centuries Points: 1103 More actions · Answer 3

You need to run some more perfmon settings to get the metrics on memory, cpu, page file, sql server usage.

Check out this msdn site for recommended perfmon analysis:

http://msdn.microsoft.com/en-us/library/aa645516(VS.71).aspx

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 4

GSquared (9/2/2008)
I'd start by finding out what queries are slow, then find out why. More often than not, that's the problem. Run a trace if you don't know which ones to start with.

I second the idea of QSquared. Just out of curiosity, What is the Config of the server? What kind of Raid set up do you have. Maybe the queries tht are running could be optimized to have less page reads. That can decreae the IO bottle neck you are facing.

-Roy

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 5

I ran into this exact same problem on Friday... a couple of scheduled jobs had failed and restarted... they apparently made a mess of things in the SQL Server Agent. I temporarily disabled the failed jobs from running, bounced the SQL Server Agent, and then reenabled the jobs. Everything has been running hunky dory since then. Then, I rebuilt the jobs that had failed and now they, too, run fine as does the rest of the server.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)