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.