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 Point North Networks Server and/or Remote Probe that accesses the server).

· Oracle: Oracle 10g, 9i, 8i and Oracle 7 (requires default TCP Port Setting 1521).

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