InterSystems Open Exchange

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>`

mypButtons

What's new in this version

mypButtons

Background

What's new compared to other tools

How to run

Example steps to create your IRIS server's performance graph with ^mypButtons

About Logo

Tag version: 1.0.0

Released: 2023-11-15 05:37:34