Hi, I am new to PRTG and have got stuck with a problem trying to monitor our SQL 2017 databases. Basically it doesn't matter what we do we cannot find any sensor that will list the databases and allow us to monitor them . We were assured PRTG can but cannot find how. I have added the SQL Server (MSSQLSERVER) General Statistics sensor but that only gives logins/logouts and user connections.
PRTG and Monitoring SQL 2107 databases
Votes:
0
1 Reply
Votes:
0
Hi,
At first, we'd need to know what exact metrics you'd like to monitor? It basically boils down to retrieving these metrics via a query and then have PRTG interpret the result or result table, depending on what you're getting back. If we know the metrics, I can check if there is an existing query [from another case] that may suit your use case :)
Best,
Stephan
Created on Mar 20, 2023 12:25:18 PM 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