CODEWITHSUNDEEP
sqlsql-server
Yasin
Yasin

Reputation: 1232

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

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?

Upvotes: 4

Views: 18845

Answers (1)

Alex
Alex

Reputation: 5157

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"

Upvotes: 2

Related Questions