|
The Studio - Database Query analysis tool enables you to execute SQL queries on diverse database servers and monitor their return output within the BMC Portal environment. You need no longer run separate SQL queries.
What you can do with this tool
Monitoring Studio Express enables you to run and analyze SQL queries within your Portal environment on the following database servers:
| • | Microsoft SQL server 7, 2000 and 2005 |
| • | Oracle database servers 8, 9i and 10g |
Once set-up, you can then fine-tune your monitoring by performing string searches and numeric value extractions on the return output of the SQL queries.
Basically, if an application you wish to monitor uses a database server, you can test this database by sending applicative queries to the database server, or by testing the content of some critical application tables. Once you have specified your SQL query, you search for strings in the result set and build graphs using the numerical values returned. Queries can be set up to perform complex tasks with just the click of a button, and they can be saved for future use.
Background information on SQL
BMC Performance Manager Express Monitoring Studio runs, analyzes and monitors SQL queries on database servers using the JDBC technology.
| • | SQL: A short form of Structured Query Language, is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management |
| • | Queries: The most common operation in SQL databases is the query, which is performed most often with the declarative SELECT keyword. SELECT retrieves data from a specified table, or multiple related tables, in a database. SQL queries allow the user to specify a description of the desired result set, but it is left to the devices of the database management system (DBMS) to plan, optimize, and perform the physical operations necessary to produce that result set in as efficient a manner as possible. |
| • | Keywords like SELECT, or keyword clauses like ORDER BY, FROM, GROUP BY etc. used for SQL queries are numerous and can vary depending on the database server they are run on. |
| • | JDBC: Short for Java Database Connectivity is a Java API that enables Java programs to execute SQL statements. JDBC allows Java programs to interact with any SQL-compliant database. Since nearly all relational database management systems (DBMSs) support SQL, and because Java itself runs on most platforms, JDBC makes it possible to write a single database application that can run on different platforms and interact with different DBMSs. JDBC is similar to ODBC, but is designed specifically for Java programs, whereas ODBC is language-independent. JDBC was developed by JavaSoft, a subsidiary of Sun Microsystems. |
How it works (summary)
The 3 basic steps to run Database queries are:
| 1. | Identify the host, specify the type of database server, enter connection credentials. |
| 2. | Specify the SQL query to be executed and set thresholds with alert conditions |
| 3. | Monitoring Studio Express runs the query and displays its response under the parameter Return Output |
Fine-tune the monitoring by running string searches or performing numeric value extractions on the return output of the monitored instance.
Parameters
 Details of the parameters and alert conditions are stated in the Reference Guide.
|
