Up Prev Next
From: gavin dot mcnay at nomura dot co dot uk
Subject: Sybase Query Analysis
Date: Apr 7 1999 8:02AM
Is there a utility to get the current sybase sessions and the SQL queries that
are being run at the current time.
I've used informix before and liked the ability to tune queries that were
running on an instance (probably behind a blackbox application, where i can't
read the source.... and hence can't change the set explain on line...)
what I'd like to do is get the queries which take ages to run and tune these by
running them with the output of the optimiser being dumped...create
indexes...and the query runs faster....
Have any of you any ideas on how i can acomplish this???
Many thanks in advance,