Hello
I need an urgent help from you guys I would like to know how to use my PRTG to monitor microsoft sql db server. What are the components that would be monitored ? can it be used for disk space monitoring or performance etc...
Regards Lindy
Article Comments
Hello Dear
I wanted to know how to use the PRTG to monitor my sql Database Server... I would like to monitor the log file size of my database, monitor my database performance,monitor the size of the database and have alerts in case the database goes down. Is all these achievable with PRTG?kindly provide details about all these if you can
Regards Lindy
Dec, 2016 - Permalink
Dear Lindy
To monitor such statistics, you need to write the according SQL statements. Since those can be different for different SQL databases, we have no full reference for that. However you might fight this example helpful.
Dec, 2016 - Permalink
you mean there are different sensors for different monitoring e.g one for performance and another one for disk space monitoring could you confirm this for me?
Regards Lindy
Dec, 2016 - Permalink
Dear lindy
Beside the one sensor I linked in the first reply, we don't have dedicated sensors for SQL database metrics. The script linked in the other reply is an example how further information can be read.
You can expect the current PRTG sensors here.
Dec, 2016 - Permalink
One more clarification what is the purpose of Sensors monitoring database performance? is it only for monitoring performance and not disk space and log verification?
Regards Lindy
Dec, 2016 - Permalink
Dear Lindy
There is a sensor which shows at least some information, please find its documentation here. Similar sensors for older SQL Server versions are available as well.
If you want to monitor the disk space of the computer itself, you can use a generic Windows disk sensor.
Dec, 2016 - Permalink