Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Using SQL Profiler to Resolve Deadlocks in SQL Server RE: Using SQL Profiler to Resolve Deadlocks in SQL Server

  • December 21, 2010 at 7:41 am

    #1265076

    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