Paessler PRTG

Professional database monitor PRTG

 

  • icon check white 2
    All-in-one database monitoring
    at a glance


  • icon check white 2
    Oracle SQL, Microsoft SQL,
    MySQL, PostgreSQL & more
     
  • icon check white 2
    Avoid downtimes,
    optimize performance

 

 

 

 

 

 

Database monitoring: 5 reasons for using PRTG


database monitoring

 

  

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

View video (3:26 min.)

 A more concise overview

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

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.

Individual reports

Individual reports

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 manufactures

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.

 Global monitoring

Global monitoring

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

 

Your database monitor PRTG at a glance

 

3 examples of database monitoring with PRTG

buy blue

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.

 

ticket blue

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.

virtualization blue

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.

 

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.

 

PRTG comes with all the features you need, plus more your IT infrastructure won't want to live without.

vendors vm ware

 

PRTG monitors these vendors and applications, and more, in one view!

 

 

quote andreas reimann

“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

 

Trusted by 500,000 users and recognized
by industry analysts as a leader

 

“Fantastic network and infrastructure monitoring solution that is easy to deploy and easier still to use. Simply the best available.”

Read more reviews

“Software is absolutely perfect, Support is superior. Meets all needs and requirements, this is a must have solution if you are needing any form of monitoring.”

Read more reviews

“The tool excels at its primary focus of being a unified infrastructure management and network monitoring service.”

Read more reviews

 

The basis: databases, downtime, alarms

database

Databases

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.

error

Downtime

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.

alarm

Alarm

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-monitoring.png

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.

More information about database monitoring topics

 

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.

 

Recommend PRTG

 

Remote location monitoring with remote probes

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.

NetBrain

Integrating monitoring results from PRTG into NetBrain maps makes the foundation for network automation.

Read more

Plixer

Paessler and Plixer provide a complete solution adding flow and metadata analysis to a powerful network monitoring tool.

Read more

UVnetworks

UVexplorer integrates tightly with PRTG to bring fast and accurate network discovery, detailed device inventory, and automatic network mapping to the PRTG platform.

Read more

 

PRTG The Swiss army knife

PRTG: The Swiss Army knife for sysadmins

Adapt 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

 

arne seifert

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.

 

time white

Save effort

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.

brain white

Save time

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.

money white

Save money

80% of our customers report substantial cost savings with network monitoring. Your costs of licenses will likely pay for themselves within weeks.

 

 

 

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.

 

 

Try Paessler PRTG for free

Everyone has different monitoring needs. That’s why we let you try PRTG for free. Start now with your trial.

 

 

PRTG

Network Monitoring Software - Version 22.4.81.1532 (November 29th, 2022)

Hosting

Download for Windows and cloud-based version PRTG Hosted Monitor available

Languages

English, German, Spanish, French, Portuguese, Dutch, Russian, Japanese, and Simplified Chinese

Pricing

Up to 100 sensors for free (Price List)

Unified Monitoring

Network devices, bandwidth, servers, applications, virtual environments, remote systems, IoT, and more

Supported Vendors & Applications

More
cisco logo grey 40 dell logo grey 40 hp logo grey 40 ibm grey40 netapp grey40 linux grey40 aws grey40 windows grey40 vmware grey40 citrix grey40 exchange grey40 apache grey40 oracle grey40