We have a SQL server 2005 database with 2000 stored procedure and would to perform the performance tuning for SP.
As intial step, would like to take the detailed metrics related to stored procedure execution.So, that i can prioritize the stored procedures for tuning. Also, i would like to know the time taken by stored procedures, or the amount of resources used in their execution.
Please do needful. Thanks in Advance.