6 Replies Latest reply on Oct 18, 2021 9:44 PM by Adityan P R

    Session performance issue with SQL server ODBC driver

    Adityan P R New Member

      Hi Everyone,

       

      I'm seeing a performance degradation from our UAT to PROD environment for a session using the MS SQL server ODBC connection. Mappings are same in both the env. The connection also doesn't have any difference. Both are using 'ODBC' type connection without DSN enabled. The count of data processed is also same. Below is the only difference I found when I compared the logs for both the sessions -

       

      PROD -

       

      2021-10-13 05:01:15 : INFO : (1916 | MAPPING) : (IS | NODE_PROD) : NODE01_IVZ_INFA_PC_PROD : CMN_1021 : Database driver event...

      CMN_1021 [Microsoft SQL Server Event Using single row fetch.

       

      Microsoft SQL Server Event Using Array Inserts. connect string = [XXX\YYY]. userid = [ZZZ]]

       

      UAT -

       

      2021-10-01 05:00:27 : INFO : (8136 | MAPPING) : (IS | INT_IVZ_INFA_PC_TEST) : NODE02_IVZ_INFA_PC_TEST : CMN_1021 : Database driver event...

      CMN_1021 [Microsoft SQL Server Event Using array fetches.

       

      Microsoft SQL Server Event Using Array Inserts. connect string = [XXX\YYY]. userid = [ZZZ]]

      -------------

       

      Is this something that can affect the session performance ? If yes, Is there a way to configure this from Powercenter or DB end ?

      Any inputs are welcome, Thanks.