Home > IT Answers > SQL Server > Dealing with a hyperactive SQL Server
SQL Server Ask the Experts
2,585 pts.
 Dealing with a hyperactive SQL Server
SQL Server, SQL Server errors, SQL Server performance
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
RELATED QUESTIONS
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.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Denny Cherry
 64,550 pts.