Transcript Document
SYBASE ASE:
SYSMON PARSER
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.
ASE SYSMON PARSER: QUICK INFO
The tool is designed to parse and analyze reports generated
by Sybase ASE sp_sysmon system procedure.
The tool has been tested from 12.5.x through 15.7 ASE
releases.
The tool does not require Sybase ASE client to be present on
the local host running the tool.
The tool does require sp_sysmon report files to be present.
The tool allows focusing on a desired subsection of metrics
from one or more sp_sysmon generated report files in order to
compare them across multiple reports.
The metrics may be displayed, compared, reviewed in graph
and exported to csv file for further review.
STARTUP: SECTIONS SELECTION
[Select Sysmon Counter s] tab is designed to setup the desired selection of
metrics on the basis of which the tool will par se sp_sysmon output files.
Using the tool for the fir st time must star t here.
Select “Load Sysmon File” and then “Par se Sections”
This will result in all the available sysmon metrics displayed in the bottom -most table.
Each of the metrics may be selected (select the row and press “Add Counter”)
Sysmon repor t counter s may be selected one by one or by “Matching” with
the desired pattern. For each counter its “Type” must be chosen.
The list of selected counter s may be expor ted or saved as template
configuration (“Save Counter s”/”Expor t Sections”)
Pre-set templates may be loaded “as is” into the par ser (SysmonPar ser.ini
template is loaded automatically on tool’s star tup).
The par sing is per formed on the basis of the counter s selected .
STARTUP: REPORT FILES SELECTION
[Select Sysmon Files] tab is designed to direct SysmonParser tool
to the list of files one wishes to parse (must be present locally).
Select “Add Sysmon Files”
Select sp_sysmon generated report file(s) you wish to parse.
Any file added to the list may be deleted from the list by
selecting it and pressing [delete] keyboard key.
The parsing is performed on the basis of the files selected .
Parsing is the outcome of subtracting specified counters from all
available counters in the files specified to the tool
([counter][counter type] intersection in a single report file).
DIGEST: METRICS PARSED
[Digest Sysmon Counters] tab is designed to start applying the
selected view to the sp_sysmon report files.
Select “Start Parsing of Sysmon Files”
The tool will generate a table of the counters parsed across the
report files specified.
An average for each counter will also be displayed.
The resulting data may be either exported or inspected for
correlations.
Rows in the resulting table may be moved (drag and drop) or
deleted to eliminate useless data.
DIGEST: METRICS COMPARED
It is possible to select two metrics at a time to see correlation between the
selected metrics.
The metrics are selected either from the selection in the drop boxes, or by
moving from row to row in the table.
To display the correlation (or a single graph) select the metrics and press
“Display”.
For repor ts spanning more than one day, deselect “Time Only” check box.
SYSMON PARSER: 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.