RATE THIS ANSWER
0
Click to Vote:
- 0
0
Last Answered:
May 15 2008 7:44 PM GMT
by Mrdenny
What version of SQL Server are you using, and what patch level?
Take a look at sysprocesses or sp_who2 (or
sp_who3) 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.
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? 
