Possible Duplicate:
How to find slowest queries
In Sql Server 2008, is there any option to find out which stored procedure running slowly among all (When the no. of stored procedures is very large. Ex: 500)
Hey Kiran Please refer to this question may be it will answer you