Up Prev Next
From: gavin dot mcnay at nomura dot co dot uk
Subject: Re: Sybase Query Analysis
Date: Apr 8 1999 2:49PM
Thanks for the help.... but... (oh there always is a but)
the only problem with this is it ASSUMES you KNOW the queries taking place.
The question I was asking is How do i get an idea of the queries which are
executing on the sybase server....
Anbody got any ideas
> Two main options are available to you.
> Firstly, in isql use "set showplan on" followed by "set noexec on" and then
> your query. See on-line sybooks for description of these set commands in
> the Performance and Tuning Section. In Nomura you would have to "up"
> sybooks in your unix session first and then simply type sybooks to bring up
> the on-line documentation.
> Secondly a more elaborate details of how an index has been chosen for your
> query use the following command from an isql batch followed by the query or
> stored procedure in question.
> dbcc traceon (3604, 302)
> Notes: 3604 - Directs trace output to the client rather than to the error
> 302 - Prints trace information on index selection.
> your query...
> To turn off the output, use: dbcc traceoff (3604, 302).
> Darren Sany
> Ex. Nomura personnel.
> -----Original Message-----
> From: firstname.lastname@example.org
> To: SybPerl Discussion List
> Date: 07 April 1999 09:31
> Subject: Sybase Query Analysis
> >Is there a utility to get the current sybase sessions and the SQL queries
> > 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
> > 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,
> >Gavin McNay