Preview
Please note, that in long description you should mention:
• App's goals and functions
• How to use the app
• If it is open source app - please, provide the installation instructions
Previous value: `https://github.com/Intersystems-jp/mypButtons`
Previous value: `mypButtons`
Previous value: `GitHub`
Previous value: `Technology Example`
Previous value: `InterSystems IRIS, InterSystems IRIS for Health, Caché, Ensemble`
Previous value: `Utilities`
Previous value: `Not checked`
Previous value: ``
Previous value: `mypButtons routine creates CSV from pButtons HTML.`
Previous value: `# mypButtons
mypButtons routine creates one CSV (mgstat and Windows Performance are shown in one line) from multiple pButtons HTML files. This routine works only for Windows.
# Background
InterSystems IRIS family has a nice utility **^SystemPerformance** (as known as **^pButtons** in Caché and Ensemble) which outputs the database performance information into a readable HTML file. When you run ^SystemPerformance on IRIS for Windows, a HTML file is created where both our own performance log *mgstat* and Windows performance log are included.
It's a great report, however, you need to extract log sections manually from a HTML file and paste them to a spreadsheet editor like Excel to create a performance visual graph. Many developers already share useful tips and utilities to do it [here](https://community.intersystems.com/post/intersystems-data-platforms-capacity-planning-and-performance-series-index "InterSystems Data Platforms Capacity Planning and Performance Series Index").
Now I introduce a new utiltiy **^mypButtons**!
# What's new compared to other tools
* **^mypButtons** combines mgstat and Windows performnace logs in one line. For instance, you can create a graph includes both "PhyWrs" (mgstat) and "Disk Writes/sec" (Win perfmon) in the same time frame.
* **^mypButtons** reads multiple HTML files at once and generates a single combined CSV file.
* **^mypButtons** generates a single CSV file into your laptop so it's much easier to crete your graph as you like.
* **^mypButtons** generates a CSV and it includes columns which I strongly recommend to check as the first step to see the performance of InterSystems product. So everyone can enjoy a peformance graph with this utility so easily!
***Please Note!*** If you want to play mypButtons.csv, please load SystemPerformance HTML files with "every 1 second" profile.
# How to run
> do readone^mypButtons("C:\temp\dir\myserver_IRIS_20230522_130000_8hours.html","^||naka")
It reads one SystemPerformance HTML file and store the information into a given global. In this sample, it reads *myserver_IRIS_20230522_130000_8hours.html* and store it into *^||naka*.
> do readdir^mypButtons("C:\temp\dir\","^||naka")
It reads all of SystemPerformance HTML files under a given folder and store the information into a given global. In this sample, it reads all HTML files under *C:\temp\dir* and store it into *^||naka*.
> do writecsv^mypButtons("C:\temp\csv\","^||naka")
It generates the following three csv files under a given folder from a given global.
* mgstat.csv
* perfmon.csv
* mypButtons.csv
Here, mypButtons.csv includes the following columns by default, which I strongly recommend to check first to see the performance:
* mgstat: Glorefs, PhyRds, Gloupds, PhyWrs, WDQsz, WDphase
* perfmon: Available MBytes, Disk Reads/sec, Disk Writes/sec, % Processor Time
This utility works for InterSystems IRIS, InterSystems IRIS for Health, Caché and Ensemble for Windows.
# Example steps to create your IRIS server's performance graph with ^mypButtons
Please see [GitHub readme](https://github.com/Intersystems-jp/mypButtons/blob/main/README.md) to see how to create the graph step by step.
# About Logo
Logo Icon : <a href="https://www.flaticon.com/free-icons/analysis" title="analysis icons">Analysis icons created by mynamepong - Flaticon</a>`
Previous value: `https://github.com/Intersystems-jp/mypButtons/blob/main/LICENSE`
Previous value: `https://community.intersystems.com/post/enjoy-checking-intersystems-iris-performance-useful-tool-mypbuttons`
Previous image: