SQL Profiler

File Folder Location: PROFILER.EXE C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\ Running under a different domain… If you create a cmd file, you might need to copy over the cmd file to the profiler directory and run it from there. To filter to only Stored Procedures… Events -> Check... » read more

SQL Server Activity Monitor

The SQL Server Activity Monitor gathers information about the monitored instance and displays the data in a series of collapsible panes.  Right Click Server -> Activity Monitor The Activity Monitor is split up into a couple of different panes. Overview Processes Resource Waits data file input output Recent expensive queries Active expensive queries