Name | Modified | Size | Downloads / Week |
---|---|---|---|
Parent folder | |||
ratios | 2019-06-13 | 4.1 kB | |
ratios.README | 2019-06-13 | 968 Bytes | |
Totals: 2 Items | 5.1 kB | 0 |
Program: ratios Author: David Kleppinger dkleppinger@dts.edu Perl script to calculate Read-ahead utilization, Bufwaits Ratio, and Buffer Turnover ratio. Usage: ratios [<profile> [<period>]] If no parameters given it runs onstat -p to get the current profile information and does it's calculations. <profile> is the name of a file containing the output of a previously run onstat -p. If a <period> is given it will calculate the BTR base on <period> minutes since reset. Warnings: Uses onstat -c to get BUFFERS. If BUFFERS has been changed recently it will report BR/BTR incorrectly when run on a <profile> file created before the change. If no parameters are given it requires Jonathan Leffler's sqlcmd to get the time since last reset of the statistics. Future development: Use SMI tables directly instead of onstat. Use DBI::Informix instead of onstat/sqlcmd. Allow BUFFERS to be passed as a parameter.