https://communities.sas.com/t5/Decisioning/SAS-RTDM-Performance-logging-interpretation-tips/m-p/790682#M31 <P>Hi!</P> <P>&nbsp;</P> <P>The question in understanding what is written to RTDM Performance log and how to map the SQL query with the activity.</P> <LI-CODE lang="java">2022-01-09 15:39:32,968|TableCacheJDBCLoader||TableCacheJDBCLoader.select() times(nanos)[Prepare: 4701 Execute: 448799 SQL: SELECT SOMETHING FROM SOMEWHERE WHERE SOMEID = ?] 2022-01-09 15:39:32,968|TableCacheJDBCLoader||TableCacheJDBCLoader.select() times(nanos)[Prepare: 3675 Execute: 319816 SQL: SELECT SOMETHING2 FROM SOMEWHERE2 WHERE SOMEID2 = ?] 2022-01-09 15:39:32,968|ACTIVITY_TIME||Activity GeneralIORead.SCReadTable took 991644 nanos 2022-01-09 15:39:32,968|TableCacheJDBCLoader||TableCacheJDBCLoader.select() times(nanos)[Prepare: 3528 Execute: 444013 SQL: SELECT SOMETHING3 FROM SOMEWHERE3 WHERE SOMEID3 = ?] 2022-01-09 15:39:32,968|ACTIVITY_TIME||Activity GeneralIORead.SCReadTable took 732798 nanos 2022-01-09 15:39:32,968|ACTIVITY_TIME||Activity GeneralIORead.SCReadTable took 830829 nanos</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>1. What do the numbers in the <STRONG>Prepare</STRONG> and <STRONG>Execute</STRONG> parameters mean before the database query text? If everything is clear with activity (GeneralIORead.SCReadTable took 991644 nanos) - reading time in nanoseconds, then these parameters raise questions with their interpretation.</P> <P>&nbsp;</P> <P>2. In this example, there are 3 records with queries to the database and 3 records with a report of the time of the corresponding activity. Is there a way to unambiguously map them with each other? From the log entry, this is at least not obvious.</P> Tue, 18 Jan 2022 13:36:53 GMT HULK 2022-01-18T13:36:53Z https://communities.sas.com/t5/Decisioning/SAS-RTDM-Performance-logging-interpretation-tips/m-p/790682#M31 <P>Hi!</P> <P>&nbsp;</P> <P>The question in understanding what is written to RTDM Performance log and how to map the SQL query with the activity.</P> <LI-CODE lang="java">2022-01-09 15:39:32,968|TableCacheJDBCLoader||TableCacheJDBCLoader.select() times(nanos)[Prepare: 4701 Execute: 448799 SQL: SELECT SOMETHING FROM SOMEWHERE WHERE SOMEID = ?] 2022-01-09 15:39:32,968|TableCacheJDBCLoader||TableCacheJDBCLoader.select() times(nanos)[Prepare: 3675 Execute: 319816 SQL: SELECT SOMETHING2 FROM SOMEWHERE2 WHERE SOMEID2 = ?] 2022-01-09 15:39:32,968|ACTIVITY_TIME||Activity GeneralIORead.SCReadTable took 991644 nanos 2022-01-09 15:39:32,968|TableCacheJDBCLoader||TableCacheJDBCLoader.select() times(nanos)[Prepare: 3528 Execute: 444013 SQL: SELECT SOMETHING3 FROM SOMEWHERE3 WHERE SOMEID3 = ?] 2022-01-09 15:39:32,968|ACTIVITY_TIME||Activity GeneralIORead.SCReadTable took 732798 nanos 2022-01-09 15:39:32,968|ACTIVITY_TIME||Activity GeneralIORead.SCReadTable took 830829 nanos</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>1. What do the numbers in the <STRONG>Prepare</STRONG> and <STRONG>Execute</STRONG> parameters mean before the database query text? If everything is clear with activity (GeneralIORead.SCReadTable took 991644 nanos) - reading time in nanoseconds, then these parameters raise questions with their interpretation.</P> <P>&nbsp;</P> <P>2. In this example, there are 3 records with queries to the database and 3 records with a report of the time of the corresponding activity. Is there a way to unambiguously map them with each other? From the log entry, this is at least not obvious.</P> Tue, 18 Jan 2022 13:36:53 GMT https://communities.sas.com/t5/Decisioning/SAS-RTDM-Performance-logging-interpretation-tips/m-p/790682#M31 HULK 2022-01-18T13:36:53Z https://communities.sas.com/t5/Decisioning/SAS-RTDM-Performance-logging-interpretation-tips/m-p/790691#M32 <P>Are you familiar with/worked with prepared statements?</P> Tue, 18 Jan 2022 14:32:39 GMT https://communities.sas.com/t5/Decisioning/SAS-RTDM-Performance-logging-interpretation-tips/m-p/790691#M32 Prasenjit_Sen 2022-01-18T14:32:39Z https://communities.sas.com/t5/Decisioning/SAS-RTDM-Performance-logging-interpretation-tips/m-p/790693#M33 Prasenjit_Sen, no. Can you please tell me how this is related to my question about the interpretation of messages in the log? Tue, 18 Jan 2022 15:11:13 GMT https://communities.sas.com/t5/Decisioning/SAS-RTDM-Performance-logging-interpretation-tips/m-p/790693#M33 HULK 2022-01-18T15:11:13Z