Using SQL profiler to trace TaskMan instances
To use SQL Profiler to see which instance of TaskMan is monitoring an application database:
- Start the SQL Server Profiler.
- In SQL Profiler, select .
- Connect to the application database server you want to trace.
- On the Events Selection tab, remove everything from the Events column except TSQL -- SQL:Batch completed.
- On the Data Columns tab, add Server Name to the Selected Data Column.
- To start the trace, click .