SQL Query Monitor

neilgmt

Wonder if anyone could help.. on our previous monitoring software (WhatsUp Gold) we were able to create a SQL Query monitor that would run a sQL Query against a db and if the number of rows returned was less than 5 the monitor would be up.  Any more than 5 and the monitor would be down.

Is there the equivalent functionality available within APM?

I have found the SQL Server User Experience Monitor but when entering the query and all details and testing it states "failed with 'Down' status Query must return at least 1 row"

Obviously correct as currently no errors log but would prefer it if did not have to return a single row.

lukas.belza

Hello,

You can use "SQL Server User Experience Monitor" and write SELECT command that returns number of rows of your original SELECT command (this command returns always the number of row in the first cell):

SELECT COUNT(*) FROM ....

Then you can use Threshold settings - e.g. you can set Critical Threshold to "greater than" 5. When your original SELECT command returs more than 5 rows, the component will be set to "Critical" status and you can trigger some alert action.

Also you can use "Warning" threshold (or leave it blank).

Note: The "Down" status in SQL monitor is primary used for fatal errors like "can't connect to database"...

I hope that helps.

Thanks,

Lukas Belza (SolarWinds development)