Thanks smoothcriminal. But I have few questions. Can you tell me steps to test the performance in PRODUCTION server. I am completely aware that we shouldn't put loads on production server by using sql profiler but I am curious to know your practice while you worked on production server for performance test. Is Auto_update_statistics is turned on your server coz I heard it put locks on tables.