Hello,
I have a SQL Server with 3 instances; in each room there are 5 databases. How can I monitor the status of the databases? That is, mounted (normal) and / or disassembled (offline) BBDD. Is it necessary to generate a sensor by DB?
Thank you
Status Database MSSQLSERVER
Modified on 2025-06-10 12:54:11 +0200
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.
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.
Hi Keko,
yes, please create a new sensor for each instance.
First, please add a new PRTG device with the SQL Server's IP address. On this device, please add a "Microsoft SQL v2" sensor for each instance you are running on this server. You can specify the database and also the instance of your Microsoft SQL Database in the sensor's settings page.
Please find more information about the sensor here: https://www.paessler.com/manuals/prtg/microsoft_sql_v2_sensor
Kind regards
Andreas Günther, Technical Support
Apr, 2018 - Permalink