Professional database monitor PRTG

Database monitoring: 
5 reasons for using PRTG

Ticket Database

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.

Online shop

With PRTG, you can track your stock. When your online shop is booming, your warehouse often takes a heavy hit. PRTG will promptly notify those in charge so they can deal with the situation quickly.

Turnover

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.

“The support we received from Paessler AG was extremely reassuring. Their reaction time, know-how, and solutions were outstanding in every department.”

Andreas Reimann, Senior Networking Communication Architect at Zürich Airport. Zürich Airport uses more than 4,500 sensors for its monitoring. To the case study (german)

The basics:
Databases, downtime, alarms

Database provides:
PRTG has sensors for them all

PRTG comes with 200+ 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. For this database, PRTG offers the  Microsoft SQL v2 Sensor.
• 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.

FYI:

WMI Microsoft SQL sensors will let you call up specific information from your databases. This sensor is available in four versions: 2008, 2012, 2014, and 2016. Find out more in our blog post, "Sensor of the week: Microsoft SQL Sensor."

Over 95% of our customers recommend PRTG

Paessler AG worldwide trialled PRTG in over 600 IT departments.
The aim was to tune the network monitoring software closer to the needs of the administrators.
The result of the survey: over 95% of the participants would recommend PRTG - or already had.

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 works in the Paessler AG support department.

You want to know more about other network-related monitoring topics?

Here you find everything about...

PRTG as docker monitoring tool

NAS monitoring with PRTG

Operating system monitoring

Monitoring server availability

PRTG saves worry

Setting up PRTG is quick and easy. You can access as many sensors as you need to monitor your databases. And thanks to its 200+ predefined sensors, you'll have no trouble detecting the causes of crashes.

PRTG saves time

With PRTG, you get one central monitoring tool for monitoring your SQL databases and servers. Our dashboard provides a quick and concise overview at all times - whether on your desktop or as an app.

PRTG saves money

80% of our customers report substantial or even exceptional cost savings in the area of database monitoring. The experience of our customers shows that the costs for licenses have paid for themselves in an average of a few weeks.

Award winning solution

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:

Q & A: How can I monitor error tables in SQL databases?

Q & A: How can I monitor strings from an SQL database?

Q & A: How to setup the SQL v2 sensors in PRTG? Is there a guide?

PAESSLER AG –
German quality
engineering

• Unlimited version of PRTG for 30 days
• After 30 days, PRTG reverts to a free version
• Or, you can upgrade to a paid license anytime

Most administrators want to test a tool for free before deciding to make an investment.

The many advantages of PRTG:

1. Free trial version: Take the time to explore PRTG so you can determine if it satisfies your needs and meets your expectations. Once the trial is over, it’s easy to upgrade your already configured version of PRTG, which means you’re much less likely to make an incorrect purchase.

2. One tool, one overview: Administrators often use a variety of monitoring solutions for their network or for the individual components of their infrastructure. But using several different tools every time you want to create an overview costs time and energy. PRTG is an “all-in-one” solution. Our dashboard and app provide a comprehensive overview, whenever you want it.

3. Quick customer support: Got a question? Stuck on a problem and need a hand? PRTG is backed by a dedicated development and support team. We do our utmost to answer every customer inquiry within 24 hours (on business days). Browse all our support topics here.

Configure your PRTG today. The trial version is free of charge. Save time, worry, and money with our monitoring tool designed for your network and entire infrastructure.

Related topics

• MIB Browser
• AWS Monitoring

• Packet Capture
• Bandwidth Management