Creating an alert to test SQL Query Results

purdue98

I received a request to execute a SQL Query and send an alert if it returns data.  If the SQL Query returns no data/NULL data, then no alert is to be generated.

If this possible to alert on a NULL data?  It's my understanding that the SQL Server User Experience Monitor performs a query, retrieves data, and compares that data to your Statistic. 

Can you set the statistic to NULL?  I thought the Statistic had to be a number.

 

Please advise.

jiri.tomek

Hello,
SQL user experience monitor takes value of the first column in the query and compares it with thresholds. If it is NULL, result is zero. If you want to distinguish between NULL and zero, you can write query like this:

IF (SELECT ... FROM ...) IS NULL SELECT 0 ELSE SELECT 1

Now if your inner SELECT returns NULL, statistic is zero, otherwise statistic is one. Set thresholds to "greater than 0" and if your SELECT is not NULL, component goes to warning/critical state.