SQL Server Sensors

Using the SQL Server sensors you can natively monitor the most used SQL servers: MySQL, Microsoft SQL, and Oracle SQL. Basically, the sensors monitor whether the database server process accepts and processes requests. Additionally you can run a custom SQL command and check the return values.

The following fields are particular to these sensors:

·      Database Name – 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 and Password – provide the username and password to login to the database.

·      SQL Expression – provide an expression with which to fetch data. When a cursor is returned, only the first row will be fetched.

·      Result Set – check this checkbox if your SQL expression returns a result set. Then the value of the first column of the first row of the result set is used as value of the monitoring request (e.g. will be compared to the limits). Otherwise the “number of affected rows” is regarded to be the value of a monitoring request.

The sensors support the following server versions:

·      MS-SQL: SQL Server 2005, SQL Server 2000, SQL Server 7 and MSDE (requires OLE DB installed on the machine running the IPCheck Server and/or Remote Probe that accesses the server). Enter MS-SQL specific data in the respective section.

·      Instance Name – This holds the name of the instance if you want to connect to a ‘named instance’, otherwise it remains empty.
Note: Sometimes you see connection strings like SQLSERVER\SQLINSTANCE in database clients. The first part is the server name that was configured in the general server settings. The second part is the instance name mentioned here. Do NEVER enter the string in this form in the instance field of the sensor setup page, only the second part (and without the backslash)

·      Port – If your SQL Server runs the instance at a different static port than 1433 you can enter the port number in this field. If your SQL Server uses the default value of 1433 or is configured for dynamic port setting then leave this field empty.

·      Oracle: Oracle 10g, 9i, 8i and Oracle 7 (requires default TCP Port Setting 1521). Enter Qracle Specific Data in the respective section.

·      Interface– Oracle offers 2 possibilities for connection to the server, either via direct TCP/IP communication (SQL-NET) or via the Oracle Client Interface (OCI). Select the one you want to use for this sensor.

·      Port – With SQL-NET you have to supply the TCP/IP Port for the connection in this Field. Usually the default value of 1521 is correct. With an OCI connection the setting of the port property is ignored.

·      MySQL: MySQL server 5.0, 4.1, 4.0 and 3.23.