Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

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

>To: SybPerl Discussion List 
>Subject: Re[2]: 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 
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 
>> 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: 
>> 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 
>> 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 
>> >
>> >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