September 1, 2007 at 5:58 am
I come across the ASYNC_DISKPOOL_LOCK on this server while restoring a database using LiteSpeed. The process is extremely slow. Aneone has idea how to fix on-fly or how to fix it in future?
Many thanks to any input in advance
September 1, 2007 at 2:33 pm
Hi,
It looks like a disk bottleneck. Check it, and if it is, then try to lower the number of virtual devices in LiteSpeed (I don't know how they call it exactly, the point is that decreasing the parallelism can decrease the disk load). This is a next-time solution, I have no idea about on-fly solution because you can't change the number of the virtual backup devices in an existing backup, only for future ones. Ideal solution: buy faster disk subsystem
If I missed the cushion, then please write the solution, I have some LiteSpeed backups as well...
-- Erik http://blog.rollback.hu
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply