August 9, 2010 at 1:14 pm
Hi All,
The restore database is taking for ever on sql server 2000 sp4 /windows server 2003 64 bit.
when I see sp_who2 active I see Disk I/O's Column are less than 100 for long time. The only actitvity going on the server is restore command
I checked taskmanager/Perfmon and database server activity for performance issues,Memory looks good , 10 utilization on CPU(which is absolutely nothing), no errors in event logs.
The only thing I noticed is is avg disk queue lenth is 100 % most of the time but I dont see any disk activity from sql end or server end.
Any help is really appreciated in troubleshooting this issue......
August 9, 2010 at 1:20 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic966186-5-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply