Up Prev Next
From: "Lee Falkenhagen" <falkenl at hotmail dot com>
Subject: Re: Re: Sybase Query Analysis
Date: Apr 8 1999 3:34PM
There are products out there such as DBVision from Platinum or use
ASE Monitor Server if you are sa.
>To: SybPerl Discussion List
>Subject: Re: Sybase Query Analysis
>Date: Thu, 8 Apr 1999 15:49:59 +0100
>Thanks for the help.... but... (oh there always is a but)
>the only problem with this is it ASSUMES you KNOW the queries taking
>The question I was asking is How do i get an idea of the queries
> 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"
>> your query. See on-line sybooks for description of these set
>> the Performance and Tuning Section. In Nomura you would have to
>> sybooks in your unix session first and then simply type sybooks to
>> the on-line documentation.
>> Secondly a more elaborate details of how an index has been chosen
>> query use the following command from an isql batch followed by the
>> stored procedure in question.
>> dbcc traceon (3604, 302)
>> Notes: 3604 - Directs trace output to the client rather than to
>> 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
>> > are being run at the current time.
>> >I've used informix before and liked the ability to tune queries
>> > running on an instance (probably behind a blackbox application,
>> > read the source.... and hence can't change the set explain on
>> >what I'd like to do is get the queries which take ages to run and
>> these by
>> > running them with the output of the optimiser being
>> > indexes...and the query runs faster....
>> >Have any of you any ideas on how i can acomplish this???
>> >Many thanks in advance,
>> >Gavin McNay
Get Free Email and Do More On The Web. Visit http://www.msn.com