Skip to Content
avatar image
Former Member

Need Query for CPU Consuming Process in Sybase ASE

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 13 at 04:25 PM

    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

    Add comment
    10|10000 characters needed characters exceeded