Results 1 to 2 of 2

Thread: Msg 1205 Transaction (Process ID 75) was deadlocked on lock |

  1. #1
    Join Date
    Mar 2003
    Posts
    383

    Msg 1205 Transaction (Process ID 75) was deadlocked on lock |

    Hi:

    On a production SQL2000 STD sp4 server,

    1. I have dropped 10 tables with each around 1-2 gb in DB ABC
    2. I had run DBCC ShrinkDatabase (ABC, 20) and it is failed after running 133 hours this morning. Yes, 133 hours.

    It ran 72 hours last month and shrinked from 200 gb to 180 gb.
    Thus, I expected it should be <= 72 hours to fnish since 10 more tables are dropped ?

    Msg 1205 Transaction (Process ID 75) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

    DBCC shrinkDatabase will cause deadlocking? how to avoid it?
    Is there other ways to speed up?

    thanks
    -D

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Did you see blocking during that time period? That will slow down db shrinking. What kind of apps use the db? Maybe deadlock on system tables, check sql server log for details.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •