Using SQL Profiler to Resolve Deadlocks in SQL Server

  • sameera33

    SSC Enthusiast

    Points: 142

    Thanks Jonathan. I was able to see the resources after I saved the xdl file as a txt.

    The deadlocks happen when executing an SSIS sequence of packages. What is strange is that the identical packages run fine on sql2005 server, but they frequently deadlock in sql2008. The deadlock most often invloves an alter index rebuild all statement and an update.

    Are there differences between SQL 2005 and 2008 that could potentially cause the deadlocks?

    Thanks

    Sameera

  • Jonathan Kehayias

    One Orange Chip

    Points: 26778

    Not that I know of, but its possible that there might be. Without the deadlock graph its hard to know what is occurring behind the scenes leading to the deadlock. I would look first at the two schema's and the list of indexes to see if there is a difference there. Is there a filtered index in 2008? Was an index added?

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

  • Dennis Post

    SSCarpal Tunnel

    Points: 4473

    Thanks Jonathan!!

    This really made things a lot clearer for me.

    Don't know if there are better techniques now days, but this one's a keeper!!



    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

Viewing 3 posts - 46 through 48 (of 48 total)

You must be logged in to reply to this topic. Login to reply