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: Database Bottlenecks.Deadlocks, Database Indexes, Indexes, Monitoring, MS SQL 2000, MS SQL 2005