Solutions

Status Database MSSQLSERVER

Modified on 2025-06-10 12:54:11 +0200

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

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 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

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.

Status Database MSSQLSERVER

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.