Skip to Content
0

Need Query for CPU Consuming Process in Sybase ASE

Feb 13 at 05:55 AM

55

avatar image
Former Member

It must includes like SQL Text, Login, SPID, CPU TIME etc...

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Avinash Kothare Feb 13 at 04:25 PM
0

Look at following MDA tables and grab what you need.

- monProcessSQLText (for SQL text)

- monProcess/monProcessActivity/monProcessStatement for Login, SPID, CPU usage, I/O etc.

Note that the usages are in cumulative counters.

So you will need to take snaps at desired times (e.g. 1 Minute) and then take deltas between two counter values,

Processes that start and finish within the delta may be hard to catch !

You can also get third party tools like DPA (Solarwinds), Surveillance (BradMark), pDBA (White Sands) and many more !

HTH

Avinash

Share
10 |10000 characters needed characters left characters exceeded