disk activity is running at 100%

5 pts.
Tags:
SQL Server administration
SQL Server performance
SQL Server security
24 hrs ago disk i/o and activity shot up to 100* with quues grwoing. our average i/o queue is normally around zero with disk activity at <15% we have had this before - lasts a couple of days and then stops. we have never found out why? can anyone help?

Answer Wiki

Thanks. We'll let you know when a new response is added.

What version of SQL Server are you using, and what patch level?

Take a look at sysprocesses or sp_who2 (or <a href=”http://itknowledgeexchange.techtarget.com/sql-server/upgrade-for-sp_who2-called-sp_who3/”>sp_who3</a>) and see what processes are using the most disk resources.

You can also make sure that SQL Server is actually the application which is causing the IO to spike. In Performance Monitor select Process from the Performance Object list. Select the IO Data Operations/sec counter, and the sqlservr from the instance list. This will show you the IO that SQL is doing. If this number isn’t about the same as the total IO number than something else is hitting the disks pretty hard.

Often this will be an anti-virus or defrag utility running on the SQL Server’s console which causing these problems.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following