Monday 18 April 2011

ASE : How to see the sql running on ASE

In Oracle, there is nice feature that we can see the top sql statement running. In Sybase, it’s not easy. But there is
work around. searching sybase support site, there seems a few way to do this. The most practical ways are

1) run dbcc traceon(3605), dbcc pss(0, spid, 0), dbcc traceoff(3605)

2) run dbcc traceon(3604), dbcc sqltext(spid), dbcc traceoff(3604), the limitation of this is there is 400 byte
limitation.

Other options are 1) monitoring server, which requires extra setup 2) third party tool, which requires extra dollar.
They are not possible at my site.

No comments:

Post a Comment