Work with SQL performance monitor in Run SQL Scripts

To start an SQL performance monitor from Run SQL Scripts:

  1. Open Run SQL Scripts.
  2. From the Monitor menu, select Start SQL Performance monitor for this job.
  3. On the New SQL monitor dialog, select a name and a library.
  4. You can change the jobs to monitor on the Monitor jobs tab.

You can only attach one monitor at a time to a job. If you attempt to monitor a job that is already being monitored, you will receive an error message.

From the Monitor menu, you can also delete, end, analyze, and view the properties of an SQL performance monitor.