Solved

Sybase, How to check statement which currently executed by spid

Posted on 2009-07-11
7
3,621 Views
Last Modified: 2013-02-27
Hi,
In sql server dbcc inputbuffer / sql profiler will tell me what currently specific spid does, I will able to know in details what is current statement being executed.
How about in Sybase ?? sp_who is not enough information
0
Comment
Question by:motioneye
7 Comments
 
LVL 14

Expert Comment

by:shru_0409
Comment Utility
http://www.sybase.com/detail?id=20450
this link may be useful for u
0
 
LVL 6

Accepted Solution

by:
IncisiveOne earned 500 total points
Comment Utility
(Sybase ASE is a much bigger, more feature-rich beast that runs on a variety of plaforms ... quite different to MS SQL.)

It depends on the version, and what options you have installed in the server.

Try, this works on all versions:
> dbcc sqltext (spid)

I trust you know to first exec:
> dbcc traceon (3604)

The SQL buffer size that will be displayed is subject to config parms

Cheers
0
 

Author Comment

by:motioneye
Comment Utility
dbcc sqltext new to me :), okay let me try to find out, hmm I'm running on 15.0.2
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 6

Assisted Solution

by:IncisiveOne
IncisiveOne earned 500 total points
Comment Utility
In that case, you can also use:

> sp_showplan <spid>, null, null, null

Cheers

0
 

Author Closing Comment

by:motioneye
Comment Utility
Thanks IncisiveOne, I know sometimes my questions are too  simple for you guys, but this the matter of me to get quick answer as the company direction go with sybase...u will hear more soon.. anyway I have downloadedmost pdf doc from syabse for day learning... thank again for support me
0
 
LVL 6

Expert Comment

by:IncisiveOne
Comment Utility
My pleasure
0
 

Expert Comment

by:aimsupport
Comment Utility
nice.

that is working gud for sybase.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
Find out what Office 365 Transport Rules are, how they work and their limitations managing Office 365 signatures.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

744 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now