This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Raw Signal Wait Time Custom Metric

Within DPA, click on "Options" at the top right of the UI.

On the "Monitor Setup" tab, look to the right and you should see a "Custom Metrics" button - click on that.

Click "Create New Custom Metric".

Fill in the fields appropriately. (see image below)

Adjust the value for the warning or critical level for when you want to be notified (or leave unchecked if you just want to start plotting signal wait time as a raw metric.

You will want to use a delta since the counter we're querying is cumulative.

Also, if you have a different query you use to collect this data, feel free to use one to your liking!

SELECT SUM(signal_wait_time_ms) AS [SignalWaitTime]

  FROM sys.dm_os_wait_stats

pastedImage_1.png