3438360 - How to monitor performance of dependent stored procedures before and after the table locking scheme is changed. - SAP ASE

• We are trying to change the table locking scheme from allpages (APL) to datarows (DOL) for a heavily used table.
• We want to monitor performance of dependent stored procedures before and after the change.
• How to monitor performance of stored procedures?
• What information about performance of stored procedures can be collected and how?

SAP Adaptive Server Enterprise 16.0

dependent stored procedures, table locking scheme optimization, performance, stored procedure monitoring, execution time analysis, logical read metrics, physical read metrics, MDA monitoring tables, monProcessProcedures table, monProcess table, monProcessActivity table, alter table lock operation, index statistics update, recompile stored procedure, workload analyzer tool, CPU usage analysis, I/O performance analysis , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To