SQL Servers Sensor Types

Using the SQL Servers sensors you can natively monitor the most commonly implemented SQL servers: MySQL, Microsoft SQL, and Oracle SQL. The sensors monitor if the database server accepts and processes requests. Additionally, you can run a custom SQL command and check the return values.

PRTG supports native monitoring for the following SQL Servers:

• Microsoft SQL Server: Checks Microsoft SQL server connections.
• MySQL Server: Checks MySQL server connections.
• Oracle SQL Server: Checks Oracle SQL server connections.

Common Settings for all SQL Sensors

• Database: In this field, the name of the database or the path of the database can be entered in order to access the database information.
• User/Password: Please enter your SQL server's credentials. When using a Microsoft SQL server, you can also choose to use the Windows Authentication, if probe computer and the Microsoft SQL Server are in the same domain.
• SQL-Expression: Provide an expression to fetch data. When a cursor is returned, only the first row will be fetched.
• Result Set: Select this checkbox if your SQL expression returns a result set. Then the value of the first column in the first row of the result set is used as the return value of the monitoring request (i.e. will be compared to the limits). Otherwise, the "number of affected rows" is regarded to be the return value of a monitoring request.

Notes for Microsoft SQL Sensors

• Supports SQL Server 2008, SQL Server 2005 (including SQL Server Compact Edition), SQL Server 2000, SQL Server 7 and MSDE (requires OLE DB installed on the machine running the PRTG probe that accesses the server).
• Instance: This holds the name of the instance if you want to connect to a "named instance", otherwise this field should remain empty. Note: Sometimes you will see connection strings like SQLSERVER\SQLINSTANCE in database clients. The first part is the server name configured under the general server settings. The second part refers to the instance name mentioned above. Never enter this complete string in this PRTG form, merely provide the second part (without the backslash).
• Port: If your SQL server runs the instance at a different static port than 1433, you can define the port number here. Select "Manual" and change the port number.

Notes for Oracle SQL Sensors

• Supports Oracle servers 11g, 10g, 9i, 8i, 8.0, and 7.3, including Oracle 10g Express and Oracle 8i Personal and Lite editions (requires default TCP Port Setting 1521).
• Connections work through direct TCP/IP communication (SQL-NET).
• Port: You need to supply the TCP/IP port for the connection in this field. Usually the default value of 1521 is correct.

Notes for MySQL Sensors

• Supports MySQL server 5.1, 5.0, 4.1, 4.0 and 3.23.

Continue