Hi, I'm looking to create a sensor to use with SQL 2008 R2 servers to check for blocking. I have several potential custom queries which work for this, but the way they operate is under normal conditions they return nothing at all. In the event of a blocking condition they return the details. Is there a good sensor to use for looking at blocking? If not, I'm happy to use the SQL query sensor but it looks as if I'd have to set it up such that a negative response is, in fact, a positive result. If it returns any data at all, then that's actually a negative response.
I've set this up but the sensor immediately goes into an error status as it reports the query has not returned a valid data table...which is OK and expected.
Any thoughts on how best to accomplish this task?
Thank you! Adam