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.