Create Windows Performance Monitor Counter Alert from Data Collector



By:
Overview

We can also create performance counter alerts by right-clicking our data collector set and select "New" > "Data Collector". 

create new data collector

Once selected we get a new window where we can add another Performance counter data collector or any of the following other types: Event trace data, Configuration data or a Performance counter alert.  We won't go through all the different types here, but we will go through adding a Performance counter alert as it is the other type that I find most useful.   To configure this item we use the following window to give it a name and select the "Performance counter alert" radio button.

create new data collector set

After we click "Next" we get the following window where we can add the counters that we would like to monitor.  Clicking "Add" will open the same window we used earlier when adding performance counters to monitor in real time.  Once you have selected the counter you can define when this alert is triggered.  For this example, we will alert when the total CPU is above 90%.

create new data collector set

After clicking "Next" we get the following window where we complete the creation of this data collector.  In this step we also select the "Open properties for this data collector" before clicking "Finish" so that we can also setup the actions when the threshold for this alert is exceeded.

create new data collector set

Within the properties dialog box for the performance counter alert data collector you can setup other tasks to run from the "Alert Task" tab.  You can also start another data collector set, from the "Alert Action" tab.  I usually just log an entry to the Windows event log so I can go back later and look at other data collector logs for that timeframe to investigate.

new data collector properties

Last Update: 3/13/2019





More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download


get free sql tips
agree to terms


Learn more about SQL Server tools