mvillegascuellar

less info
61 reputation
8
bio website dbamemories.wordpress.com
location Lima, Perú
age 30
visits member for 2 years, 8 months
seen Sep 6 '13 at 20:27

SQL Server DBA Oracle DBA


Jul
2
awarded  Curious
Oct
7
awarded  Popular Question
Mar
25
comment SQL Server deadlock too long
yes, it finally became deadlocked
Mar
11
awarded  Scholar
Mar
11
accepted SQL Server deadlock too long
Mar
11
awarded  Commentator
Mar
11
comment SQL Server deadlock too long
I tried this, however it always get locked when the truncate table is executed. The sys.partitions is the one that holds the lock.
Mar
11
comment SQL Server deadlock too long
Thank you Aaron, I think this what happened. I suppose that this kind of behavior is odd and should not happen again. I will try to use something else to monitor it.
Mar
11
awarded  Supporter
Mar
11
comment SQL Server deadlock too long
OK I get it however I want to know why SQL Server took 5.5 hours to realize there was a deadlock?
Mar
11
awarded  Editor
Mar
11
comment SQL Server deadlock too long
You are right the sys.partitions was the one blocked by the truncate table. Now I only have pending the reason why SQL Server did not killed the deadlock process after 5.5 hours???
Mar
11
comment SQL Server deadlock too long
I have updated the post to show the full first query.
Mar
11
revised SQL Server deadlock too long
added 1678 characters in body
Mar
11
comment SQL Server deadlock too long
I understand but I do not understand why the first query shown on the error log gets blocked by a truncate table.
Mar
11
comment SQL Server deadlock too long
Hi, the lock has already disappeared, and I cannot reproduce it.
Mar
11
asked SQL Server deadlock too long
Oct
10
comment Unknown database corruption: Data error in cyclic redundancy check
The backup is SQL Server native. I am backing up to a local drive and there is plenty of space. The database is about 20 GB I don't know which table is corrupt but the tables I have queried returned the correct results.
Oct
10
asked Unknown database corruption: Data error in cyclic redundancy check
Jul
27
asked DMZ server unable to connect through SQL Browser