Month: February 2013

Understanding, Analysing and Troubleshooting Deadlocks – Part2

In First Part Understanding, Analysing and Troubleshooting Deadlocks – Part1 we discussed what is Deadlock, How SQL Server engine behaves when a deadlock is encountered, how a victim is identified and why deadlocks occurs etc. After reading the error message people often think that either this is the only information SQL Server has for the …

SQL Server Day | Gurgaon | 16-Feb-2013

SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And this time we are coming again to Gurgaon. We bring you rock star speakers and panelists from the MVP community & Microsoft. This is yet another opportunity to learn maximum from SQLServerGeeks.com across India. There will be …

Understanding, Analysing and Troubleshooting Deadlocks – Part1

A deadlock occurs when two or more tasks permanently block each other by each task having a lock on a resource which the other tasks are trying to lock. In simple language, Deadlock is a situation when two or more processes are waiting to acquire lock on resource(s) which are already blocked by opposite participant …