|
 Monitoring Studio Express is a Performance Manager specifically designed for BMC Portal; consequently, it uses the same common features and procedures of BMC® Portal. Please refer to your BMC Portal guides for basic knowledge on how to use the Portal. This document assumes that the user knows how to use the Portal and therefore explains procedures only related to BMC Performance Manager Express Monitoring Studio, and not on how to add Elements, Element Profiles etc…
To create a MySQL Server query instance
| 1. | Go to the Configure tab, click on the element on which you wish to use the tool. |
 If the element was created using Element Profile then add the new application class through the same route.
| 2. | On the Element Properties page, scroll to the Application Class section, click on Add. |
| 3. | On the Add Applications page, select Miscellaneous from the drop down category list and click Next. |
All application classes belonging to the BMC Performance Manager Express Monitoring Studio package are listed under Miscellaneous.
| 4. | On the Available Application Classes page, select Studio - SQL Query (MySQL Server) and select the number of instances you wish to create, click Next. You can create up to 10 instances at this stage, or create just 1 now and add others later. |
| 5. | You arrive at the Properties and Credentials page. Enter the information required for setting up the Studio - SQL Query (MySQL Server) instance and click Add. |
Information required for monitoring
|
|
|
Descriptive Label
|
Label describing the application class/monitoring tool
|
Collection Interval
|
Frequency of collection (monitoring/polling). Unit: Minutes (Default 5 minutes)
|
Credentials
Connect As
Password
Credentials
|
Login used to connect to the database server
Password associated with the above login
Shared credentials used for authentication
|
Hostname
|
Hostname or IP address of the remote element (Appears by default)
|
Port
|
The port number on which the MySQL database server is running
|
Database Name
|
Enter the database name of the MySQL server.
|
Timeout After
|
Unit: Seconds. Maximum execution time before timeout is reached
|
Debug Mode
|
Yes enables the debug mode, while No disables it. The debug output produced is stored on the RSM server in a file located at:
%RSM_HOME%/RSM(xx)/SEN_MS/sen_ms_debug_dbQuery_hostName.log.
Do not leave the debug mode enabled for too long as the debug file may grow indefinitely.
|
| 6. | Enter the information and click Next and you arrive at the Properties and Credentials page asking for the Input properties of the new instance. Enter the required input: |
Input Properties
|
|
|
Descriptive Label
|
Enter a label to describe this new SQL query instance.
|
SQL Query
|
Enter a SQL query to be executed.
Note: Single SQL query stored in a file on the RSM can be executed using the %{FromRSM:filename} macro
|
| 7. | Either click Next to arrive at the thresholds setting page, or, add a string search or a numeric value extraction for this SQL query instance. The string search and numeric value extraction instances can also be set later on this instance. |
| 8. | On clicking Next the input properties are displayed grayed-out. This page allows you to verify, edit or delete the newly-created instances and/or add another instance for the same element. If the information is correct, go on to the next step. |
| 9. | You are at the Thresholds, Properties and Credentials page. Set/modify thresholds and alert conditions: |
By default, the Connection Status and Query Status parameters are enabled to raise an Alarm if the connection to the database fails or if the query is not executed before timeout occurs.
You can modify this setting if it does not suit your requirements. Thresholds and alerts can be set for each parameter. Check the Warning and/or Alarm boxes next to the parameters to activate alerts as per your specific requirements. See details of parameters and alert conditions in the Reference Guide.
Thresholds can be set or modified at any time by clicking on the element > Configure > ”application class name” > Edit Thresholds, Properties and Credentials.
| 10. | Click Finish. Changes have been Saved message pops up, and an icon appears in the left pane of the window displaying the newly-created instance. You can also see the new instance of the class under Application Classes. |
You have successfully remotely executed an SQL query on a MySQL server and can now monitor it.
Editing or Deleting an instance
To edit or delete the instance, follow the regular procedure as for all Performance Managers on the Portal, or see Editing or Deleting an Instance.
|
