SQL monitoring software PRTG

SQL monitoring software PRTG

 

  • A comprehensive database monitoring tool
    A comprehensive database monitoring tool

  • Microsoft SQL, Oracle SQL, MySQL, PostgreSQL
    Microsoft SQL, Oracle SQL, MySQL, PostgreSQL
     
  • reduce downtime, optimize performance
    Reduce downtime,
    optimize performance

  • SQL queries at a clance
    Important SQL
    queries at a glance

 

Free Download

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.

 

 

 

 

 

SQL server monitoring tool:
Three good reasons to go with PRTG

 

Concise overview

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

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

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 like in the data center, you'll be notified at once.

 

SQL server monitoring:
PRTG sensors
 

iWhat is a sensor?

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


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 the PRTG 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.
 
k2 Net Solutions

www.k2netsolutions.com

One of the 200,000 PRTG 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.

 

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

PRTG can be started within minutes and it's compatible with many mobile devices.

 

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

 

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

 

 

Switching to PRTG safe and easy


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

 

No extra charges

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 offers you the ability to try all the sensors PRTG has to offer.

Ease of use

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

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.

 



 

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

Steffen Ille, Bauhaus-University of Weimar, Germany

 

An introduction to SQL monitoring with PRTG

 

 

3 examples:
Detailed SQL server monitoring with PRTG
 

Ticket system

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

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

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.

 

Trusted by 200.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

 

 


Free Download

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.

 

 

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.

Find out more about log monitoring here >

 

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.

 

 

Practical tip: “Hey Stephan, do you have any tips for VoIP monitoring?”

“To simulate a telephone that uses the same network as your real IP telephone, simply set up our QoS Reflector Script on a Raspberry Pi and connect the latter to the desired point on the network. By doing so, you can guarantee that you are measuring the right network path with our QoS Round Trip Sensor. This is important because VoIP traffic is usually treated with priority.”

Stephan Linke, technical support at Paessler AG

 

 

PRTG simplifies your day

Our monitoring software works for you and promptly notifies you of potential issues.
It frees you to concentrate on your day-to-day tasks with peace of mind.

 

PRTG saves time

With PRTG, you get one central monitoring tool for your servers and entire network. Enjoy a quick overview of your whole infrastructure via our dashboard and app.

PRTG saves worry

Customizing PRTG is a breeze. Getting started or switching from another network monitoring tool is easy thanks to the PRTG auto-discovery and pre-configured device templates.

PRTG saves money

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

 

 

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.

Recommend PRTG

 

PRTG: The swiss army knife for sys admins

Adapt PRTG individually and dynamically to your needs relying on a strong 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
  • New REST API Sensor: Monitor almost everything that provides XML or JSON

 
also of interest

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.

PRTG monitors the quality of your VoIP-connections. By preventing malfunctions and verifying service level agreements, you’ll save time and money. Read more about IP SLA Monitoring here.

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

Real-Time Monitoring: By monitoring your network in real time, you’ll be sure to always know what is going on inside it. PRTG runs in the background and promptly notifies you if a problem arises. 

 

PAESSLER AG –
German quality
engineering

Free Download
  • 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

 

Made in Germany: The PRTG Network Monitoring Tool is the fruit of an engaged team. The company was founded by Dirk Paessler. The Paessler AG headquarters are located in the city of Nuremberg, in the heart of Germany. We combine typical German virtues such as high quality standards, industriousness, and commitment with international, cosmopolitan flair. Read more about our firm here. By the way: We are regularly looking for new recruits.

Case Studies: Airports, utility companies, banks, colleges, hospitals: PRTG is present in every industry. For each of our customers, business and organizational processes depend on the proper functioning of the network infrastructure. The PRTG customer satisfaction is close to 100%. Read in our case studies how our customers use PRTG.

Product tests: It goes without saying that we are convinced by the quality of PRTG. But what about the others? PRTG has always performed extremely well in tests. PRTG user “LanLine” sums it up best: “PRTG was already good several years ago, and has gotten better from version to version ever since.” Such has been our steadfast and sincere goal. Read more about monitoring software product tests and comparisons here.

Support: Our support team works hard every day to help customers solve their monitoring problems. Our goal is to resolve all inquiries within 24 hours (on business days). We've drafted a comprehensive manual and built up an extensive knowledge base featuring videos, webinars, and FAQs. All support, of course, is also included!

Getting started is easy: The trial version is free, which means you can try our monitoring tool risk-free. To switch to another version of PRTG, simply search for an appropriate license. You can upgrade any time you like.

 

 

PRTG

Network Monitoring Software - Version 20.1.55.1775 (January 22nd, 2020)

Hosting

Download for Windows and hosted version 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