I have a sensor set to do a simple SQL query. During a particular timeframe, there seems to be a conflict with other SQL jobs running on the database server. My sensor query is often chosen as the deadlock victim during that time, resulting in an alert. I already have it set to go to Warning on the first occurrence and then Down on a subsequent one. Is there a way for me to set the sensor to ignore the failure due to deadlock and not alert if my SQL query is the deadlock victim?
Please log in or register to enter your reply.
Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.