RE: Performance monitoring - INFORMIX-SE

Graeme The performance tools for SE are purely Unix. See the sar command (man sar). There are other tools, such as top, that are available on the internet (I dont have the address) which needs to be compiled on your SCO version and will list current activity on your machine. When running sqls you can "set explain on" to get the Informix optimiser to output a file (sqexplain.out) containing its decision on the chosen path for that sql on that database. Murray Wood -----Original Message----- From: Graeme Muirhead [SMTP:g.muirhead@freeuk.com] Sent: Saturday, August 14, 1999 6:37 AM To: informix-list@iiug.org Subject: Performance monitoring - INFORMIX-SE Can anyone suggest how to monitor the performance of a Standard Engine database on a SCO UNIX system. What tools and utilities are available and how do you interpret the results. Thanks Graeme Muirhead g.muirhead@freeuk.com