Viewing 3 posts - 1 through 3 (of 3 total)
We had the same issue. Initially we did not think it was memory bottlenecks since cache hit ratio was around 100. But we increased the server memory and the issues...
September 19, 2012 at 1:07 pm
#1539759
I had the same issue. It had to do with a schema changed being applied via linked server. I killed the spid and the blocking was gone..
September 29, 2010 at 8:41 pm
#1229436
This could also be due to the fact the log file drive for the SQL Agnet was changed. To fix the issue change the registry to point to the new...
August 2, 2010 at 10:16 am
#1201112