How to test performance of the stored procedure in SQL Server Management Studio

Question

I want details time taken for the execution of the stored procedure. I have tried by cleaning DB cache, but getting difference in seconds resolution only.

Is there any build in method or tool of SQL server to get the detail statistics for the performance of the stored procedure?

Answer 1

You can use Profiler to capture information (including duration) about SP and individual queries in it. You can also use Display An Actual Execution Plan to how your queries are executed.

• To launch a profiler from SSMS go to Tools->"SQL Server Profiler"
• To "Display An Actual Execution Plan" go to Query->"Display An Actual Execution Plan"