RATE THIS ANSWER
0
Click to Vote:
- 0
0
Last Answered:
Jul 2 2008 6:43 AM GMT
by Mrdenny
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.
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? 
