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