SQL monitoring software PRTG

 

Free Trial
No limitations for 30 days
Freeware Download
100 Sensors, perfect for small networks


SQL server monitoring tool:

Three good reasons to go with PRTG

Concise overview

PRTG measures the time an SQL query needs for its entire request, including the establishment of the connection, the execution of the query, the handling of the transaction, and the termination of the connection.

The execution time appears immediately on your PRTG dashboard. You can also monitor and process your query's return values.

 

 

Easy setup

PRTG comes with preconfigured sensors for all major databases, such as Microsoft SQL and Oracle SQL, which are often used by larger companies, and MySQL and PostgreSQL.

 

 

Overall solution

PRTG lets you monitor your entire network. Serversrouters, switches. You get one centralized monitoring tool for everything. If the problem lies somewhere other than in the SQL database, you'll be notified at once.

 

 

SQL server monitoring: PRTG sensors

 

Monitoring SQL servers with PRTG is simple and convenient. To do so, PRTG provides a selection of preconfigured sensors.

  • Oracle SQL: Oracle is used mostly by larger companies. For Oracle, PRTG features the Oracle SQL v2 Sensor.
  • Microsoft SQL: Microsoft's database solution is also used often, both by corporate groups and medium-sized companies. For Microsoft SQL, PRTG offers the Microsoft SQL v2 Sensor.
  • MySQL: MySQL, an open-source application, is used by a multitude of websites, as well as by small and medium-sized companies. For MySQL, use the MySQL v2 Sensor.
  • PostgreSQL: PostgreSQL is also an open-source database system. Use PRTG's PostgreSQL Sensor to monitor a system of this kind.
  • More databases: If you use a database that is not listed above, give our ADO SQL v2 Sensor a try. This sensor can monitor any data source made available via OLE DB or ODBC. That means you can also use it to monitor your cloud database if other sensor types are inappropriate for doing so.

One of PRTG’s 200,000 customers: the Vienna Music Association

“We were especially worried about the functioning of our online tickets sales system, which thanks to PRTG runs like a charm. In particular, now we are much better prepared for peak hours. And even when bottlenecks arise, the monitoring software shows us exactly where the problem lies so we can take action immediately.”

Peter Hamm, Vienna Music Association IT Director.

Over 800 sensors are used to monitor the software and hardware in this famous concert hall. Online ticket sales, tickets, and appointments are stored in an SQL database. To the case study (in German)

 

PRTG lets you keep an eye on your
SQL databases – even on the go

PRTG is installed in a matter of minutes and can be used on a wide variety of devices. 

interfaces.png

Switching to PRTG safe and easy

There are many monitoring tools on the market. PRTG has the following advantages:

No extra charges

license will enable you to experience PRTG in its entirety. You'll get every sensor, as well as the notification system. We offer the utmost in transparency during the purchasing process. The free trial version comes with 100 free sensors, and during the trial you can also try all the sensors PRTG has to offer.

 

 

Ease of use

Open-source tools like Nagios have certain advantages. But they also come with the drawback that you have to develop a great deal on your own if you hope to enjoy sophisticated monitoring. PRTG is a comprehensive, professional solution with speedy support.

 

 

Extensive monitoring

Many administrators use a variety of different monitoring tools for special situations. Managing such a combination of tools takes time and energy. And that translates into countless working hours which could be spent more efficiently. Furthermore, you usually don’t get a concise overview.

 

quote-stefan-ille.png

“The greatest advantage of PRTG? You get to rest easy“

Steffen Ille, Bauhaus-University of Weimar.

Screenshots  
An introduction to SQL monitoring with PRTG

 

Quote Stefan Linke

Practical tip: Hey Stephan, what would you recommend looking out for when monitoring SQL?

“SQL sensors not only read numerical values, but can also display strings from the query in the sensor message, such as the current SQL version. See my knowledge base post to find out how this works."

 

Stephan Linke, Paessler Technical Support

 

 

3 examples: Detailed SQL server monitoring with PRTG

Ticket system

A company uses a ticket system to process orders. During peak hours, several orders arrive at the same time. PRTG quickly sees that the ticket system is overloading and sounds the alarm. Designated workers are informed by way of customizable notifications, and can quickly take action before the system crashes.

 

Online store

Most online stores have a direct link to their warehouse management systems. As sales increase, a company’s stock decreases. PRTG promptly informs designated workers so they can order new goods. Even suppliers can be informed via the PRTG notification system.

 

Visitors

How many visitors are currently on your website? How much was generated today in sales? How high are your current online advertising costs? PRTG provides easy-to-understand visuals on this and other data, data which, for example, can be displayed on a screen during a company meeting.

Requirements for SQL monitoring

 

 

SQL Server Monitoring with PRTG can be used with the following SQL server versions:

  • MS SQL: Microsoft SQL Server 2005 or later
  • Oracle: Oracle 10.2 or later
  • MySQL: MySQL server 5.0 or later
  • PostgreSQL: PostgreSQL 7 or later

Find out more about setting up a database monitoring scenario with SQL server sensors in our online manual

SQL monitoring: definition, examples, uses, costs

Definition

SQL (structured query language) is a database language. Queries are performed with SQL to process database information. Several different manufacturers, including Oracle and Microsoft, use SQL for their databases.

Examples 

1. You can execute a query with SQL sensors to extract and monitor the following information from your online store's database: number of one-off orders, total number of orders, average order value, and names of customers. 

SELECT count(idorder), sum(value), avg(value), GROUP_CONCAT(customer SEPARATOR ', ')
from test.order

 

 For more detailed information on this example, please see the following post in our knowledge base: https://kb.paessler.com/en/topic/70618

2. Since SQL sensors only display strings and are unable to monitor them directly, in this article we describe how you can send an SQL query and still obtain a sensor status that is based on strings. 

Assume you request the "emotional state" of your colleagues, a request that returns strings: 

SELECT
    [Name],[EmotionalState]
FROM
    [employee];

 

Rebuild the query so the status is mapped according to integer values: 

SELECT
    [Name],
    CASE
        WHEN [EmotionalState] = 'Good' THEN 1
        WHEN [EmotionalState] = 'Sad' THEN 2
        WHEN [EmotionalState] = 'Angry' THEN 3
        ELSE 0
    END as EmotionalState
FROM
    [employee];

 

Now all you have to do is define the corresponding lookups and you will already get a sensor status that is based on strings.

 

Uses

It is highly recommended that you use professional monitoring to monitor your SQL server or SQL databases. Complex SQL queries can have negative effects on database performance. PRTG allows you to monitor and optimize SQL performance. The results: increased customer satisfaction and employee productivity. With the right SQL statement, you can also keep an eye on the size of log tables. You will immediately notice if there is a sudden jump in the number of log entries, which may be a sign of some major problems in your database.

 

Costs

PRTG offers a flexible licensing model for both SQL server monitoring and general network monitoring. Get started with our free version, then customize your license to meet your own specific needs.

 

PRTG makes your job easier!

You have enough things to worry about.
PRTG not only increases the reliability of websites, it also makes life easier for IT SysAdmins. 

PRTG saves time

PRTG is a centralized monitoring tool for your entire network. Switches, routers, servers, work stations, devices...Enjoy a quick overview at all times via our dashboard and app.

 

 

PRTG saves worry

PRTG is quick and simple. 200+ sensors and pre-configured device templates make it easy to get started with PRTG or switch from another network monitoring tool.

 

 

PRTG SAVES MONEY

80% of our customers report substantial or even exceptional cost savings in the area of SQL monitoring. The experience of our customers shows that the costs for licenses have paid for themselves in an average of 3 ½ months.

Over 95% of our customers recommend PRTG

Paessler AG created an extensive survey to interview more than 600 IT departments worldwide who use PRTG. The goal of this survey was to optimize and fine-tune our network monitoring software to better meet the needs of administrators.

One survey result: More than 95% of the participants would recommend PRTG - or have already done so.

 

Award winning solution

We work hard on making our software as powerful and easy-to-use
as possible for our customers each and every day.
Of course it makes us proud when we get awards for that.

 

awards

PRTG:
The Swiss Army Knife for Admins


Adapt PRTG individually and dynamically, to your specific needs, using the API:

  • HTTP API: Access monitoring data and manipulate monitoring objects using HTTP requests
  • Custom Sensors: Create your own sensors for customized monitoring
  • Custom Notifications: Create your own notifications to send alarms to external systems
box.png

Also of interest:

 

Server Monitoring: Web, mail, virtual... PRTG provides comprehensive monitoring for all your servers. Get tips and information on the right sensors for monitoring here.

Database Monitoring: There are many aspects to database monitoring. Check out our database monitoring page for some practical examples and tips.

VMware monitoring: PRTG is a long-time, certified VMware technology partner. Our monitoring tool lets you monitor the full range of VMware products. Find our more on our VMware Monitoring page.

 

 

 

 

PRTG is the PAESSLER AG's network monitoring tool. Our software is used by more than 200,000 administrators worldwide, whether it be to monitor their hardware and server performance, their virtual environments, or the availability of their websites. PRTG is a network analysis solution for Windows. 

Our network monitoring software was created in 1997 by Dirk Paessler. The software firm Paessler AG is located in Nuremberg, Germany. We are driven by the highest standards as we continue to develop our software. And should you ever encounter a glitch, our support team usually answers inquiries within 24 hours.

Set up SQL monitoring with PRTG. You'll save time, worry, and money. PRTG is installed in a matter of minutes. You get 100 free sensors, plenty for small networks. Upgrade whenever you like. 

 

Download

Network Monitoring Software for Windows - Version 17.3.32.2478 (July 25th, 2017)

Languages

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

Pricing

Free for up to 100 sensors (Price List)

Unified Monitoring

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

Supported Vendors & Applications

                    More >>

Related Topics

Copyright © 1998 - 2017 Paessler AG