Dealing with a hyperactive SQL Server
On occassion, our SQL Server goes hyper - 100% disk activity with I/O queues. It happens only once a year, lasts for a couple of days and then stops. We have our database administration staff look at it, but we have no real idea what the cause is. Can you suggest a direction or idea?

Software/Hardware used:
ASKED: June 30, 2008  7:31 PM
UPDATED: July 2, 2008  6:43 AM

Answer Wiki:
Something that happens only once per year is going to be very hard to track down. There are no internal events which happen at that frequency. And I'm sure that the server is rebooted more often than that. My first guess would be that it's a user event that is causing it. Some sort of massive database query that takes a couple of days to run, and is only run once per year. Unforunately I'd need to look into the system and get a lot more information before being able to provide you with any real direction.
Last Wiki Answer Submitted:  July 2, 2008  6:43 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 64,550 pts.