We recently upgraded a server to SQL Server 2008 R2. The server had been running SQL Server 2005. We are using
- Transactional Replication
- Management Data Warehouse and Data Collector on the Production server
We are starting to see deadlock errors in the application log. This did not happen in SQL 2005.
On the reporting database I can replicate a deadlock using an "ad-hoc" query with an inner join and table scan on an active table. However, I can run reporting procs that take minutes to complete with no problems.
Is sql 2008 more sensitive to deadlocks to sql 2005? I am going to start undoing some of the changes we have implemented and tested. Before I go that route I wanted to see if anyone else has noticed increased deadlocks when upgrading to 2008 R2.