Extracte del document "Progress RDBMS Performance Tuning Tips"
(D:\Documents\Progress\Docs\PSC & JohnSadd\psc_tuning.htm)

Llibres
-------

"Sun Performance and Tuning" by Adrian Cockroft, published by Sunsoft Press. isbn: 013-149642-3


Mr. John Campbell has published several useful and interesting Progress books. Among them are: 
"High Performance Coding: A Guide to Efficient Reports and Programs" 
"Making Good Progress" 
"Work Smarter, Not Harder" 
All of the above are available from:

white star software, po box 51623, palo alto, ca 94303. 
Mr. Campbell's telephone number is: 4158570686. He can also be reached via e-mail at info@wss.com and on the web at www.wss.com

Mr. Dan Foreman's "Progress Performance Tuning Guide" is an excellent reference. 
Mr. Foreman can be reached by telephone at 770.449.9696 and via e-mail at danf@prodb.com and on the web at www.usiatl.com. 


Unix tools
----------

Some useful tools that are commonly available on Unix systems are:

cp - copy a file 
df - shows available space on filesystems 
du - shows disk uage by directories and files 
fuser - identify processes using files or file structures 
glance - HP-UX system and process activity monitoring tool 
iostat - report i/o statistics 
ipcs - show ipc (shared-memory, semaphore, and msg queue) status 
last - show last login time and date for user or tty 
lsattr - AIX, shows the attributes of devices 
lslv - displays information about a logical volume or the logical volume allocations of a physical volume 
mpstat - show multi-processor statistics 
netstat - show network status and report statistics 
nfsstat - show Network File System (NFS) status and report statistics 
no - displays or sets network options 
ping - send ICMP Echo request packets to a network host 
ps - report process status 
pstat - print system facts 
sadp - disk access profiler 
sar - system activity reporter 
showmount - show all remote mounts 
spray - send a stream of packets to a network host and report transfer rate 
time, timex - time the execution of a command 
top - display information about the top cpu consumer processes 
trace - trace system calls and signals 
traceroute - print the route packets take to a network host 
truss - trace system calls and signals 
vmstat - report virtual memory, paging, and disk statistics 
w - who is logged in and what they are doing 
who - who is logged in on the system 
whodo - who is logged in and what they are doing  


Windows NT Tools
----------------

The following tools are available for Windows NT systems.

Performance Monitor - a graphical tool for performance measurement. Includes charting, alerting, and reporting functions. 
Event Viewer - a tool for monitoring the Windows NT event log 
Quick Slice - shows active processes and threads with percentage of cpu utilization 
Process Viewer - shows detailed information about active processes 
SMS - Windows NT System Management Server 


Progress Tools
--------------

The following tools are provided by Progress:

Promon - a database monitoring/activity reporting tool 
Proutil dbanalyse - reports space usage, fragmentation, etc on tables and indexes 
The 4GL Profiler - reports which procedures are called, how often, and how long they take 
The 4GL - use it to instrument your application 
Virtual System Tables - Database manager activity, usage and status data from 4GL or SQL