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
Recently I came across a very interesting issue, which I feel I should write about it. During load testing of web based application, I came across an issue where in response time for couple of the business process was exceeding a lot compare to SLA’s given to us. Test was almost clean with less than • Read More »
Tags: Dirty Reads, Locks, Lost Update, MS SQL 2000, MS SQL 2005, Table level locks
Working on the shared environments or clustered environment is quite a challenge and getting the best performance out of the servers requires that we understand as how servers are been designed or maintained in the infrastructure. If during the load testing, we are continuously seeing a very high response time which continuously exceeds the SLA’s • Read More »
Tags: Default Setting, Memory, Monitoring, MS SQL 2000, MS SQL 2005, Shared