Anything Is Better Than Nothing
Everyone should always have some basic performance logging running on their production machines. Even something as simple as this PROMON screen scraper (based on the sample from "A DBA's Guide to Databases Under Linux" ) is priceless when trying to track down performance problems.
You may not be having a problem today but if you ever do get into trouble you'll be much more prepared to deal with it.
This is free & easy -- if you don't have anything better available go ahead and install it. It only takes a few minutes and it can save you a world of hurt. Do it now.
#!/bin/ksh # # A script that defines environment variables like # $DLC etc... . /usr/local/sysadmin/config # Set this to the name of the database being # monitored DBNAME=$1 ; export DBNAME # Set this to the directory that the db is located # in DBDIR=/db # Write the log files to /var/log/dbname/mm.dd # This helps keep them organized. # DT=`date "+%m.%d"` TM=`date "+%H.%M"` TMP=/var/log/$DBNAME/$DT mkdir -p $TMP chmod 775 $TMP cd $DBDIR/$DBNAME # Go to the R&D menu, set the page size # 1 status # 7 buffer cache # 4 processes # 3 active transactions # 2 activity # 13 shared resources $DLC/bin/promon $DBNAME > $TMP/mon.$TM \ <<- "EOF" 2> /dev/null R&D 5 1 9999 p 4 60 p 1 13 p p 1 7 p 4 3 p p p 2 1 p 3 x EOF # Go to the R&D menu, set the page size # 3 other # 2 io by process $DLC/bin/promon $DBNAME > $TMP/iop.$TM \ <<- "EOF" 2> /dev/null R&D 5 1 9999 p 3 2 x EOF # Go to the R&D menu, set the page size & sampling # interval # 2 activity # 1 summary # sample for 60 seconds # various summary stats $DLC/bin/promon $DBNAME > $TMP/sample.$TM \ <<- "EOF" 2> /dev/null R&D 5 1 9999 3 60 p 2 1 s p 3 p 4 p 5 p 6 p 7 p 8 p 10 p 11 p 12 p 13 x EOF # Get some helpful data from the OS ps -elf > $TMP/ps.$TM # iostat -x 10 2 > $TMP/iostat.$TM # # vmstat 10 10 > $TMP/vmstat.$TM
Greenfield Technologies knowledge of business, applications, and infrastructure helps companies to develop and deploy applications which are built to last and designed to exceed user expectations.
-- Rob Lux
Enterprise Services Manager
Large Global IT Outsourcing Firm
With technology evolving at an increasingly challenging rate, it’s great to have a partner that you trust, and one that you can leverage to help your business take advantage of a constantly changing technology landscape. Greenfield Technologies has been there for us in the past, and will be THE partner we go to in the future when we need in-depth expertise.
-- Todd Lunsford
CIO
Quicken Loans
Greenfield Technologies in depth knowledge of the Progress database and our application made it possible to not only prepare our hardware, operating system and Progress software upgrade to a point that we felt very comfortable to go ahead with it, but also enabled us to execute it in less time than anticipated and resulted in a much larger performance improvement than we expected! Tom’s motto to prepare well and test twice beforehand paid off fully.
-- Gabriela Summerer-Herndon
Unix Admin, Progress DBA
Columbia National Inc.
We just watched! You deserve the credit! Thanks again!
-- Alex Hillman
Thank you for your extraordinary efforts during the past few days. All of us really appreciate it. Given our volume and customer service requirements, your support -- which extended far beyond the normal work day and schedule -- was invaluable.
-- Jenne Britell
Thank you again for going the "extra mile".
-- Ben Smith
Tom, you especially have gone beyond the call of duty in monitoring our system and getting issues regarding capacity etc resolved.
-- Matt White
Great program! Great features!.
-- Scott Cooper
Thank you for your work on the [...] rehosting project. Expediting the conversion of the Progress Database was critical to our success. The knowledge that you brought to the team about Progress tuning and database management helped not only with this effort but will improve our on-going management of the database. Thank you!
-- Anonymous CIO
| Address: |
White Star Software PO Box 3058 Nashua, NH 03061 |
| Cell: | +1 603 396 4886 |
| E-mail: | mailwss.com |
| wss.com | |