﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQL Server 2005 / SQL Server 2005 Performance Tuning  / Deadlocks gone? / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Thu, 23 May 2013 16:57:43 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Deadlocks gone?</title><link>http://www.sqlservercentral.com/Forums/Topic1408637-360-1.aspx</link><description>Yes, we did.  However, we think the cause was table fragmentation.Thanks!</description><pubDate>Thu, 17 Jan 2013 16:08:37 GMT</pubDate><dc:creator>david.c.wiley</dc:creator></item><item><title>RE: Deadlocks gone?</title><link>http://www.sqlservercentral.com/Forums/Topic1408637-360-1.aspx</link><description>Did you run a maintenance plan over the weekend that updated statistics or rebuilt indexes?</description><pubDate>Thu, 17 Jan 2013 15:49:07 GMT</pubDate><dc:creator>David Webb-CDS</dc:creator></item><item><title>RE: Deadlocks gone?</title><link>http://www.sqlservercentral.com/Forums/Topic1408637-360-1.aspx</link><description>Were there any changes to application code or stored procedures?Is it possible that the database was altered to set read_committed_snapshot on?Is is possible that the users just stopped using the part of the application that was causing the deadlocks?</description><pubDate>Thu, 17 Jan 2013 15:40:07 GMT</pubDate><dc:creator>Michael Valentine Jones</dc:creator></item><item><title>Deadlocks gone?</title><link>http://www.sqlservercentral.com/Forums/Topic1408637-360-1.aspx</link><description>We have a situation where we had an application that was receiving thousands of deadlocks up until last Monday.  They suddenly mitigated.  There were no changes to the application server nor the database server and the number of users have not been reduced.  Any thoughts on why this happened?Regards,David</description><pubDate>Thu, 17 Jan 2013 15:14:37 GMT</pubDate><dc:creator>david.c.wiley</dc:creator></item></channel></rss>