SYBASE ASE: MDA TABLE ASSISTANT

Sybase Administration Tools available at: http://andrewmeph.wordpress.com

mailto: [email protected]

Rev. 6.2012

NOTE AND DISCLAIMER:

 The tools posted on the blog will require the same setup: 1.

2.

3.

Sybase Client installed (for tools connecting to ASE server).

Administrative login user (for tools doing ASE administration).

A set of two or more .dll files supplied with the installation – performing licensing and environment operability checks.

  All the tools have been tested to run bug-free. Nonetheless, the tools are provided “as is.” Responsibility for running a tool lies with the user.

Comments and bug reports are welcome. They will be addressed and rectified. Please send the comments either directly by mail or through the blog.

As with any tool, it is recommended to start using it in the development environment before trying it on the Production Server.

MDA ASSISTANT: QUICK INFO

 The tool is designed to make the use of Sybase MDA tables easier. It has multiple aspects to it. On the face side, it make the MDA tables more visible and thus more easily searchable.  The tools allows to see at a glance the configuration of the ASE from the MDA point of view.  The tools makes it easier to locate the desired MDA counter, assist in constructing an SQL Query on MDA tables, and run it, collecting results, or inspecting them as a graph.

 The tool’s side effect is that it may be used as a general query execution engine. But its true force is in mining MDA tables hidden value.

MDA ASSISTANT: CONFIGURATION PANE

[Configurations] tab is designed to inspect ASE’s configuration. It has two modes: MDA configuration or an overall (Full) ASE Configuration.

It is possible to reconfigure MDA settings from the tool itself. General ASE configuration may not be changed, though.

It makes it easy to turn on/off MDA pipes or other monitoring switches.

MDA ASSISTANT: MON. TABLES

[Mon. Tables] tab is designed to mine into ASE’s MDA tables.

    Click “Get Monitoring Tables”.

Browse through the tables, inspecting its columns and the required switches.

Write a partial column name in the “Lookup” field (say CPU) and Double Click: all the columns containing the pattern will appear on the left with their descriptions.

Right click on column name to add it to SQL tab.

MDA ASSISTANT: LOG

[Log] temporary result sets / queries / &c.

tab is designed to log Available Options:  “Log Configuration”.

 “Log Results” (the result set displayed in the SQL tab).

 “Save Results” and “Auto Save” allow to save the result set to an external file (manually or one per interval of time).

MDA ASSISTANT: SQL PANE

[SQL] tab has many functions around query execution: Execute, Locate string in result set, Collect result sets, Display data in graph, Auto save/run query and/or result set, Load template queries &c. It is a query engine in a nutshell.

     “Line by line” allows writing several queries and executing them together line by line (each line representing a query), collecting the results together (with/without displaying column names).

“Auto Exec…” allow to execute the quer y at specified inter val of time.

Templates: Load/Replace/Append queries to the quer y template file to be loaded on the application star tup.

Right click on the column in a grid make available options to add the column name to the SQL editor, kill SPID, or show SPID stack -trace.

It is possible to change font definition {f}. Hide lef t/right panes {  }. &c.

MDA ASSISTANT: SQL PANE - GRAPHS

It is possible to select several columns from the result set and display the data in graph:     Click on the “graph” icon.

Select one date (or data) column for the X axis.

Select one (or two) columns for Y axis, and click “Display” to see the data as a graph.

If the query is being executed automatically at an interval, the graph WILL NOT be refreshed.

MDA ASSISTANT: FEEDBACKS

      The tool is being reworked from time to time to address changes in the ASE and align it better with ASE administrators needs.

In order to make the software better and more convenient your feedback is encouraged.

Feedback and bug reports may be made either directly to [email protected]

or posted as comments to the tool page published on the wordpress.com blog.

The blog is available at http://andrewmeph.wordpress.com

.

More tools are available there, as well as general comments on Sybase ASE, RS (and in future IQ) products.

You are welcome to post your own ideas there which may be later transformed into customized tools and posted there for download.