Archives: Database Bottlenecks.Deadlocks

Short note on using Indexes- MS SQL 2005

August 18, 2012 | By kiranbadi1991 | 1 Comment | Filed in: Database, Development, Environment, Performance Engineering, Testing.

Most often whenever Performance Engineer detects some issues  with regard to response time, the first thing the application team thinks as a fix is to check and add some more indexes to the columns in the table.Adding indexes is low hanging fruit which every development team tries and should try  before reviewing their code base • Read More »

Tags: , , , , ,

Deadlocks in MSSQL 2005 Explained

May 1, 2012 | By kiranbadi1991 | Comments Off on Deadlocks in MSSQL 2005 Explained | Filed in: Development, Environment, Performance Engineering, Testing.

Have you ever seen the below message during your load testing assignment working in the Microsoft .Net world involving ASP.NET and MSSQL Server, Msg 1205, Level 13, State 51, Line 1 Transaction (Process ID XX) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. If • Read More »

Tags: , , , ,