srivathsani-296624 (6/8/2011)
You can also use sql profiler to find out which sp in your application is taking a lot of time.You can fine tine the performance of that Sp by fine tuning the querie sin that sp with help of sql profiler and execution plans.
That's exactly what Gail was suggesting... those article are worth their weight in gold... and so much more :w00t:.