Database monitoring: 5 reasons for using PRTG
How PRTG defines sensors
In PRTG, “sensors” are the basic monitoring elements. One sensor usually monitors one measured value in your network, e.g. the traffic of a switch port, the CPU load of a server, the free space of a disk drive. On average you need about 5-10 sensors per device or one sensor per switch port.
A more concise overview
Database availability and database performance are vital elements to your business's operations. PRTG queries data from your database without lengthy query, connection, or return times. The execution time of the entire database request is displayed on your PRTG dashboard at all times.
A detailed view
Monitor specific datasets from your databases, like no other database monitoring tools do, with individually-configured PRTG sensors and SQL queries that you define yourself. These datasets may come from the ticket database or online shop (see examples). Such database monitoring will enable you to optimize your business procedures and provide employees with important information.
Would you like to use PRTG to analyze and monitor specific datasets in your databases? Then combine your database monitor with customizable reports which you can have sent to your managers automatically. With PRTG, all reporting features are included!
A variety of manufacturers
PRTG offers predefined sensors for every important database manufacturer. Among them: MySQL, Microsoft SQL v2, Oracle SQL v2, and PostgreSQL. If you use a database that is not listed here, you can often run our ADO SQL v2 Sensor. Not enough? Write your own custom sensor easily.
Thanks to the PRTG dashboard, you'll enjoy an overview of all your databases - and much more, if you so choose. With PRTG, you can monitor your entire network. This is smart, for if your databases are acting up, the problem may ultimately lie elsewhere.
This short video explains database monitoring
3 examples of database monitoring with PRTG
Many companies uses ticket databases for outstanding work orders. Paessler also uses a ticket database, e.g. for its customer support. If this database contains too many unprocessed tickets, PRTG will automatically sound the alarm. When the sensor switches to red, you'll know at once that additional staff is required.
How much does your company make per hour, per day, per week? Use PRTG to display these figures on a screen in the office where everyone can see them. Further stats, such as the number of visitors to your website, are also part of the overview.
Your database at a glance
PRTG is set up in a matter of minutes and can be used on a wide variety of mobile devices.
Trusted by 500,000 users and recognized
by industry analysts as a leader
The basis: databases, downtime, alarms
Practically every business operation at any modern company is based on information that is stored and managed in SQL (Structured Query Language) databases. For a business to be successful, these databases must always be up and running.
Database crashes can be caused by hardware errors, faulty configurations, or too little disk space or memory. Corrupted databases with defective files can also lead to problems. PRTG allows administrators to ensure their databases are constantly available and performing in an optimal manner.
PRTG features a customizable alarm system. Configure its settings in such a way as to be informed promptly - before bigger problems arise. Be alerted by email or SMS, for example. Once notified, you can quickly intervene to resolve the database issue.
Database provider: PRTG has sensors for them all
PRTG comes with 250+ predefined sensors for manufacturers like Oracle, Microsoft or IBM. During setup, PRTG pings the network and automatically creates appropriate sensors. This saves administrators a great deal of time. PRTG also provides sensors for the various different databases.
- Oracle SQL: Oracle has always enjoyed a large market share, especially in the business environment. For this database, PRTG offers the Oracle SQL v2 Sensor.
- Microsoft SQL: Microsoft's database solution is also in widespread use. With the WMI Microsoft SQL Server 2019 sensor you can monitor your SQL database. Also available for SQL 2008, 2012, 2014, 2016 and 2017.
- MySQL: MySQL is the most popular open source database, used by a multitude of websites, as well as by small and medium-sized companies. For MySQL, apply the MySQL v2 Sensor.
- PostgreSQL: PostgreSQL is also an open source database system. Use the PRTG PostgreSQL Sensor to monitor a system of this kind.
- More databases: If you work with a different database than those listed above, give our ADO SQL v2 Sensor a try. This sensor can monitor any data source which is available through OLE DB or ODBC.
We asked: would you recommend PRTG?
Over 95% of our customers say yes!
Paessler AG conducted trials in over 600 IT departments worldwide to tune its network monitoring software closer to the needs of sysadmins.
The result of the survey: over 95% of the participants would recommend PRTG – or already have.
Remote location monitoring with remote probes
Create innovative solutions with Paessler’s IT partners
Partnering with innovative IT vendors, Paessler unleashes synergies to create
new and additional benefits for joined customers.
PRTG: The Swiss Army knife for sysadminsAdapt PRTG individually and dynamically to your needs and rely on a strong API:
- HTTP API: Access monitoring data and manipulate monitoring objects via HTTP requests
- Custom sensors: Create your own PRTG sensors for customized monitoring
- Custom notifications: Create your own notifications and send action triggers to external systems
- REST Custom sensor: Monitor almost everything that provides data in XML or JSON format
Practical tip: “Hey Arne, what would you tell administrators looking to use PRTG to monitor their databases?”
“With the PRTG SQL Sensor, you can display up to ten results from one table. If it is impossible to provide results from the table to be evaluated in a fixed order, you can use the “key-value pair” in the SQL sensor to evaluate the data. Create a two-column table with SQL and identify the lines in the left-hand column which contain unique content. PRTG will then use the values from the adjacent column for the sensor display.”
Arne Seifert, technical support at Paessler AG
PRTG makes your job easier
Our monitoring software frees you to focus on other tasks by promptly notifying you of potential issues.
PRTG gives you one central monitoring tool for your servers and entire network. Enjoy a quick overview of your whole infrastructure via our dashboard and app.
Getting started with PRTG is a breeze. Setting up or switching from another network monitoring tool is easy thanks to the auto-discovery and pre-configured device templates.
3 topics from our knowledge base
Every day, our support team responds to questions from PRTG users. We aim to resolve every inquiry within 24 hours (on business days). Here are some of the most common questions regarding database performance monitoring:
Still not convinced?
More than 500,000 sysadmins love PRTG
Paessler PRTG is used by companies of all sizes. Sysadmins love PRTG because it makes their job a whole lot easier.
Still not convinced?
Monitor your entire IT infrastructure
Bandwidth, servers, virtual environments, websites, VoIP services – PRTG keeps an eye on your entire network.
|Network Monitoring Software - Version 220.127.116.112 (November 29th, 2022)|
|Download for Windows and cloud-based version PRTG Hosted Monitor available|
|English, German, Spanish, French, Portuguese, Dutch, Russian, Japanese, and Simplified Chinese|
|Up to 100 sensors for free (Price List)|
|Network devices, bandwidth, servers, applications, virtual environments, remote systems, IoT, and more|
Supported Vendors & Applications