Solved

Sybase current executing query

Posted on 2008-06-23
6
1,625 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
  • 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

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

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

Suggested Solutions

In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
Adding Computers to AD groups through an SCCM Task Sequence
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

773 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