Viewing 5 posts - 1 through 5 (of 5 total)
UPDATE... We took the server down and shipped it off to IBM. I will update once the test results come back.
November 18, 2008 at 7:04 am
It will freeze when the SQL Agent is running (which has a massive amount of SQL server jobs)
November 18, 2008 at 6:54 am
I did all that you mentioned above. Profiled, etc... Nothing that says it DB.
November 17, 2008 at 6:15 am
I think it is hardware. We are sending it to IBM today.
November 17, 2008 at 6:14 am
That was it. I have OPTION (MAXDOP 4) after each query and changed it to OPTION (MAXDOP 1) and the lines went away. Thanks!
September 23, 2008 at 10:52 am
Viewing 5 posts - 1 through 5 (of 5 total)