59 reputation
18
bio website dbamemories.wordpress.com
location Lima, Perú
age 30
visits member for 3 years
seen 2 days ago

SQL Server DBA Oracle DBA


Dec
15
revised What is the difference between MySQL Innodb log files and MySQL binary logs?
Explain why this question is not the same as the one aswered here: http://dba.stackexchange.com/questions/9174/whats-the-difference-between-transaction-logs-and-binary-logs
Dec
15
asked What is the difference between MySQL Innodb log files and MySQL binary logs?
Oct
23
awarded  Notable Question
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