SQL Server – Setup SQL Profiler to Capture Costly Queries / Stored Procedures

Click Tools >​​ SQL Server Profiler

Connect to the instance

On this page, perform the following:

• Indicate​​ Trace name

• Choose ​​ “Tuning” template

• Save to file

• Set​​ 1000​​ maximum file size

• Set trace stop time (optional. You may stop the trace anytime)

Go to​​ Events​​ Selection​​ tab

Tick​​ Show all columns​​ and choose the following columns

Click​​ Column Filters

Filter​​ DatabaseName​​ and​​ Duration​​ (>= 500ms)

Click​​ Run