September 20, 2006 at 9:28 am
I have two seperate databases in a certain instance of SQL Server 2000. A query associated with database A is showing as a locked process in database B. Can't figure out how/why. Any help?
September 20, 2006 at 9:31 am
Kill one of the processes run the query again and use profiler to c what is happening
-WM
September 20, 2006 at 9:33 am
How is it possible for database B to put a lock on a query ment for database A?
September 21, 2006 at 4:57 am
Just check the query.It must be using some table of the database B also. Also running the profiler will help u a lot.
Also just check the what is happening in the process which is getting blocked and the one which is blocking.
September 21, 2006 at 5:02 am
They might be blocking in TempDB, especuially if both are creating temp tables or running queries that require hash tables or work tables.
When you notice blocking, take a note of what resource they're both waiting on. (waitresource in sysprocesses)
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 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply