September 9, 2005 at 1:46 pm
I have 3 data transfer jobs running for hours on a 2 CPU box.
Perfmon shows CPU 100%, AVG Disk Queue Lenth > 7 and
Current Disk Queue Length > 10.
What Could be the Performance Issue?
Jagan
September 9, 2005 at 8:03 pm
Jagan,
Nothing conclusive can be said from the information you've provided. However, I think the issue may be that you're out of CPU. Do this to isolate. Check in task manager for CPU. If the 100%CPU usage is attributable to the sqlservr.exe then look in EM Current Activity to identify which threads (spid) are using so much CPU. If the spid running your data transfer jobs shows a lot of CPU activity -- a lot being 3,600,000 ms -- which is 1 hr of CPU time -- then the problem is excessive cpu on your jobs. If there are some other SQL Server threads running, then find out what these threads are doing.
Don't go the I/O subsystem or memory, until you have resolved your CPU problem.
Hope that helps.
Ben
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply