Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Analyzer
Posting Yak Master
115 Posts |
 Posted - 2015-01-19 : 14:16:08
|
| Hi,Got blocking condition, head of blocking tree is below DROP statement. sp_locks shows 100s objects the #tmptbl still has X locks on, so presume these objects are blocking the other processes.If the TSQL runs in linear fashion why has the statement not completed, still holding locks before the DROP statement is called as the last action? Profiler, sp_WhoIsActive show no blocks on the drop #tmptbl SPID. Any ideas how to fix?IF OBJECT_ID('tempdb..#Temp_tbl') IS NOT NULL DROP TABLE #Temp_tbl |
|
|
viggneshwar
Yak Posting Veteran
86 Posts |
Posted - 2015-01-21 : 02:29:38
|
| based on the amount of transaction it may take time to release the locks or to rollback the transactions. Could you please provide any simulation?RegardsViggneshwar A |
 |
|
|
|
|
|
#temp table won't drop due to object locks