sybperl-l Archive

From: "Lee Falkenhagen" <falkenl at hotmail dot com>
Subject: Re: Re[2]: 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.

Lee Falkenhagen
lfalkenh@leef.com

>From: gavin.mcnay@nomura.co.uk
>Reply-To: SYBPERL-L@listproc.net
>To: SybPerl Discussion List 
>Subject: Re[2]: Sybase Query Analysis
>Date: Thu, 8 Apr 1999 15:49:59 +0100
>
>Darren,
>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
>
>Gavin
>> 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
>> log.
>> 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: gavin.mcnay@nomura.co.uk 
>> To: SybPerl Discussion List 
>> Date: 07 April 1999 09:31
>> Subject: Sybase Query Analysis
>> 
>> 
>> >Guys,
>> >
>> >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,
>> >
>> >Gavin McNay
>> >
>> >
>
>


_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com