Skip to Content

monProcessProcedures ASE 16

Hello,

The content of monProcessProcedures monitoring table in ASE 16 as specified in the P&T manual is dynamic,i.e it is not historical in terms of the rows?

Specifically for columns:

StmtNumber, ExecutionCount,CPUTime,ExecutionTime,PhysicalReads,LogicalReads,

PhysicalWrites

each row for this columns contains information for the current procedures executed by processes now( not 1 hour ago, a day ago,etc)

Thank you

Regards

Jose

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 02, 2016 at 09:18 PM

    If you are asking, does monProcessProcedures contain any historical data or only currently running procedures? It contains currently executing procedures (no historical data)

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2016 at 02:58 PM

    Write a small test proc and see what shows up in monProcessProcedures during a handful of proc executions, eg:

    create proc testp
    as
    select count(*) from syscolumns c1, syscolumns c2, syscolumns c3
    go

    In one isql session run the above proc.

    In a second isql session query monProcessProcedures (while the proc is running in isql session #1).


    Add comment
    10|10000 characters needed characters exceeded

  • Dec 05, 2016 at 08:14 PM

    Thanks Daniel,

    Regards

    Jose

    Add comment
    10|10000 characters needed characters exceeded