SQL Server: How to use SQL Server Profile

How to trace which stored procedures are called

  • Open “Trace Properties” window
  • Select “Event Selection” tab
  • Check “Show all events”, “Show all columns” tab
  • Check “RPC:Completed” in the “Stored Procedures” event
  • Click “Column Filters” button to open “Edit Filter” window
  • Select “Database Name”, input DB name under “Like”

Be the first to comment

Leave a Reply

Your email address will not be published.


*