Skip to Content
0
Jan 24, 2019 at 04:26 PM

How to monitor stored proc recompile time at a server level (mon table?)

146 Views

I occasionally see a process with sysprocesses.cmd == "COMMAND". We're not using the statement cache (because we had replication problems with it where a simple update statement scans a big table, hanging replication). We *do* have "procedure deferred compilation" turned on (for when we create schemas from ddlgen output, it let's all objects get created successfully).

I wanted to monitor what percentage of the time ASE spends compiling statements and/or stored procs. I can't seem to find a mon table to do it. Any suggestions?

Thanks in advance
Ben Slade