Is it possible to monitor a task of a SQL database?
For example:
- Synchronization of databases between headquarters and subsidiaries
- Backing up a database (failure or success)
Last change on Nov 1, 2018 10:57:26 AM by
Monitoring the Synchronization and Backup of SQL databases
Votes:
2
1 Reply
Accepted Answer
Votes:
0
Hello Sailaish,
thank you for your inquiry.
Basically, anything that can be queried using the Structured Query Language (SQL) from the Server can be monitored with PRTG. The same goes for Synchronization or Backup Jobs. If you're able to query their status using SQL, you can monitor them with PRTG.
Here you can find some ideas:
- How can I monitor schedule jobs of MS SQL server by PRTG?
- Does PRTG can support Database backup jobs monitoring?
- SQL Last Backup Time
If you're not familiar with the SQL V2 family of sensors, you might also want to have a look here:
- How to setup the SQL v2 sensors in PRTG? Is there a guide?
- PRTG Stored Procedure sensor
- How can I monitor strings from an SQL database and show a sensor status depending on it?
Best Regards,
Luciano Lingnau [Paessler Support]
Created on Nov 1, 2018 10:56:30 AM by
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.
Add comment