ODBCSQLDURATION
From ServersCheck Wiki
Contents |
Description
The ODBCSQLDURTION check allows you to connect to a database server with the specified ODBC string connection string and then perform a SQL statement after that ServersCheck verifies the query time of database server. ServersCheck will monitor the time taken to execute the query compared to the defined time.
Definition
Besides the general settings for each check, which are similar for all checks, there are following specific settings that also need to be setup. In the Check Specific Settings, there are following fields you need to supply with parameters:
- Database Templates - If you are unfamiliar with DSN-less ODBC connections, then you can select an ODBC connection template and match it to your configuration.
- ODBC Connection string - The ODBC connection string for validation.
- SQL Statement - The SQL statement to execute.
Sample ODBC Connection Strings
Oracle ODBC driver:
Driver={Oracle ODBC Driver};Dbq=myDBName;Uid=myUsername;Pwd=myPassword
Microsoft Oracle ODBC driver:
Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=myUsername;Pwd=myPassword
Informix 3.30 ODBC driver:
Driver={INFORMIX 3.30 32 BIT};Host=hostname;Server=myserver;Service=service-name;Protocol=olsoctcp;Database=mydb;UID=username;PWD=myPwd
Pervasive ODBC driver:
Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname
Microsoft SQL ODBC driver:
Driver={SQL Server}; Server=(local); Database=myDBName; UID=sa; PWD=;
Microsoft Access ODBC driver:
Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\myDBName.mdb
Microsoft Excel:
Driver={Microsoft Excel Driver (*.xls)};DBQ=physical path to .xls file; DriverID=278;
Text File:
Driver={Microsoft Text Driver (*.txt;*.csv)};DefaultDir=physical path to .txt file;
Returned Results
This check receives as value time which is needed for an statement to be executed.
Graphs
When the graphing option is activated then ServersCheck will produce for this check two graphs: Service Level, Availability.
