Archives: MS SQL 2000

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: , , , , ,

Performance,Dirty Reads ,Lost Updates and Locks

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

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: , , , , ,

Know how shared is your server box and If Server runs with Default Settings

May 20, 2012 | By kiranbadi1991 | Comments Off on Know how shared is your server box and If Server runs with Default Settings | Filed in: Database, Development, Environment, Others, Performance Engineering, Testing.

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: , , , , ,