?
Solved

Sybase current executing query

Posted on 2008-06-23
6
Medium Priority
?
1,994 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 1000 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 1000 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

If you’re involved with your company’s wide area network (WAN), you’ve probably heard about SD-WANs. They’re the “boy wonder” of networking, ostensibly allowing companies to replace expensive MPLS lines with low-cost Internet access. But, are they …
If you are a mobile app developer and especially develop hybrid mobile apps then these 4 mistakes you must avoid for hybrid app development to be the more genuine app developer.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

719 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