Solved

Sybase current executing query

Posted on 2008-06-23
6
1,866 Views
Last Modified: 2012-06-27
Using Sybase Central, is there any way to know which query is currently executing to debug the database performance issues.
0
Comment
Question by:consultant12345
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
6 Comments
 

Accepted Solution

by:
hauie earned 250 total points
ID: 21855580
Try this

open an interactive sql session to the server you are interested in using Sybase Central

do and sp_who and see who is running queries at the moment.

dbcc traceon(3604)
go

dbcc sqltext(spid)   --- where spid is the id of the client running the query you are interested in
go

This will give you the last executed statement.  If your data server isn't a busy one, then this may help you in debugging

0
 
LVL 19

Expert Comment

by:grant300
ID: 21858129
What version of which Sybase product are you running?

Regards,
Bill
0
 

Author Comment

by:consultant12345
ID: 21896949
Hi Bill

I am using SQL Anywhere 10
0
 
LVL 19

Assisted Solution

by:grant300
grant300 earned 250 total points
ID: 21899762
Hmmm.  There are a bunch of tools available for ASE.

A look at the doc shows that ASA, via SQL Anywhere Studio, supports "Request Level Logging".  There are also some tools for manipulating the log which is both verbose and not well formatted.  You do get the complete text of each SQL statement along with some basic execution statistics.

Check out the SQL Anywhere Studio Developer's Guide.

Regards,
Bill
0

Featured Post

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
The recent Petya-like ransomware attack served a big blow to hundreds of banks, corporations and government offices The Acronis blog takes a closer look at this damaging worm to see what’s behind it – and offers up tips on how you can safeguard your…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question