Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

information on show t_c T131

Hi,

I am trying to do performance monitoring on livecache. Process is active for thread t131. I use x_cons <sid> show t_c t131 and get the below information, etc.

-


T131 User ( pid = 2248872 ) -


remote_node : oaca12qt remote_pid : 2248872

COM procedure : APS_ORDER_GET_DATA

OMS callback : SQLRequest_method callback_cnt : 31

dispatcher_cnt: 323162 command_cnt : 160887

exclusive_cnt : 104786223 self_susp_cnt : 3760

Resume count 0 total 824937 History [ T2 T2 T2 ]

state_vwait : 0 state_vsleep : 98170 state_vsusp : 37313

prio_total : 103 prio_from_oth : 103

-


However, I was expecting to see much more information per the performance primer documentation...for example:

-


T45 User ( pid = 0 ) -


dispatcher_cnt: 45122 command_cnt : 2302

exclusive_cnt : 12794233 self_susp_cnt : 41886

Resume count 0 total 275 History [ T12 T4 T2 ]

self_read_io : 4300 avg_self_rd_tm: 0.0000

self_write_io : 2419 self_write_pg : 2419 avg_self_wr_tm: 0.0006

dev_read_io : 492 rel_dev_rd_tm : 0.0006 abs_dev_rd_tm : 0.0006

dev_read_pg : 492 pages_per_io : 1.0

dev_write_io : 92 rel_dev_wr_tm : 0.0020 abs_dev_wr_tm : 0.0021

dev_write_pg : 92 pages_per_io : 1.0

state_vsusp : 2 rel_susp_time : 0.1458 abs_susp_time : 0.1458

rcv_rpl_count : 692 rcv_rpl_long : 2 avg_rcv_rpl_t : 0.0994

rpl_rcv_count : 691 rel_rpl_rcv_t : 1.1367 abs_rpl_rcv_t : 1.1369

dev_que_len_0 : 536 dev_que_len_1 : 39 dev_que_len>1 : 9

-


I am using Kernel Version 'Kernel 7.5.0 Build 039-123-135-440'

What is the reason for such a wide difference in information?

I am specifically looking for rcv_rpl_count, rpl_rcv_count, dev_read_io, etc, or more documentation on the information I do have Unfortunately, the mysql site now points us back to service marketplace, which does not have this detail.

Thanks for any assistance.

Margaret

Former Member
replied

Hi,

you have to enable this additional measurements by executing

x_cons <dbname> time enable

Kind regards

Holger

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question