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”