Solutions

Database table monitoring

Modified on 2025-06-10 14:47:34 +0200

I would like to ask if the DB monitoring tool can fire alert (through Syslog) if the number of record returned per a SQL query over the defined threshold. Eg. if I would like to monitor a customised database table called tbUser while with 2 fields (Field1 and Field2), is it possible to set up a monitor on Field2 per anyone authorised to query, with returned number of records more than a defined threshold

Article Comments

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

Hi,
depending on type of the database this should be at least possible using the ADO SQL Sensor of PRTG. You might additional have a look at the available sensor types for database servers.
Best regards

Jul, 2012 - Permalink

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.

Database table monitoring

Article CommentsAttention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

Search

Attention

Related Articles

Article Comments

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.