usp_Case_DoDel;1 SQL IO maxing out disk access
Updated: 21 May 2010 | 5 comments
This issue has been solved. See solution.
Please help. usp_Case_DoDel;1 SQL IO is maxed out.
discussion Filed Under:
Please help. usp_Case_DoDel;1 SQL IO is maxed out.
Comments
We keep getting a request
Is this the DISK IO is maxed
Is this the DISK IO is maxed out?
Liam Finn
http://www.plymouthrocklodge47.com
This SP is called when a case
This SP is called when a case has been deleted and can take a long time to run and is dependant on the number of items, searched and production runs in that case. You can see which case it is by running
So what are you saying the problem is exactly?
What version of Accelerator are you using?
Do you see any deaadlocks in SQL?
EV Backline Technical Support Engineer APJ Region
The problem was that our
The problem was that our Discovery server was using up 100% of disk time on our SQL server. After I stopped the Discovery services and the disk time drops off.
We are using 7.5 SP2
We were seeing deadlocks but I'll have to check for current locks.
We are also seeing empty SID fields .
resolved
Not that there was a clear resolution, but here are a few things that we had to do.
In DA we lowered the chunks. The SQL I/O was still at 100% disk util, however, it may have helped as the DELETE did complete and our SQL, DA, and EV servers are back to normal operation.
Would you like to reply?
Login or Register to post your comment.