Load performance on Windows 2012

[jarno_loubser]

We have a situation where a specific load script takes longer and longer as the loop goes on a Windows 2012 server (VM / .Net4.5 / QV 11.2 SR2 / 12 Cores / same data).

The exact same script runs on another server (Win 2008 R2 / fisical server / .Net4 / QV 11 SR1 / 12 Cores with hyperthreading / same data).

So the first time the loop goes through on 2012 server (Month 1) the time is 2:41, then 4:17, then 4:26, then 5:07,5:34, then stable).

On the 2008 server the performance goes 2:08, 2:22, 2:28,2:31, 2:39 then stable).

I have also copied the qv.exe from the 2008 server to the 2012 server and it did not make a difference.

On both servers the CPU is at below 10% and lots of RAM available...

Has anyone seen this happen?

Here is the loop...

FOR i = $(SalesTransMinDate) TO $(MaxDate)

IF ISNULL(date(Date#('$(i)','YYYYMM'))) THEN

ELSE

DebtorsSummaryPerMonth:

LOAD *

WHERE FABS(DebtorsTransBal) > 0.01;

LOAD

           COMPANY AS DebtorsTransCompany,

           T$TTYP&'/'&T$NINV as DebtorsTransNo,

           T$CCUR AS Currency,

           T$ITBP AS Customer,

     $(i) AS MonthYear,

     SUM(IF(

                         match(T$TREC,'13','2'),

                                   T$AMTH$1+T$AMTH$2+T$AMTH$3+T$DC1H$1+T$DC1H$2+T$DC1H$3+T$PADH$1+T$PADH$2+T$PADH$3+T$CDAM$1+T$CDAM$2+T$CDAM$3,

                                             IF(T$TREC='4',

                                                       T$AMTH$1+T$AMTH$2+T$AMTH$3+T$CDAM$1+T$CDAM$2+T$CDAM$3,

                                                                 T$AMTH$1+T$AMTH$2+T$AMTH$3))) AS DebtorsTransBal,

     SUM(IF(

                         match(T$TREC,'13','2'),

                                   T$AMTH$1+T$AMTH$2+T$AMTH$3+T$DC1H$1+T$DC1H$2+T$DC1H$3+T$PADH$1+T$PADH$2+T$PADH$3+T$CDAM$1+T$CDAM$2+T$CDAM$3-T$VATH$1-T$VATH$2-T$VATH$3,

                                             IF(T$TREC='4',

                                                       T$AMTH$1+T$AMTH$2+T$AMTH$3+T$CDAM$1+T$CDAM$2+T$CDAM$3-T$VATH$1-T$VATH$2-T$VATH$3,

                                                                 T$AMTH$1+T$AMTH$2+T$AMTH$3-T$VATH$1-T$VATH$2-T$VATH$3))) AS DebtorsTransBalExVAT,

     SUM(IF(

                          match(T$TREC,'13','2'), 

                                   T$AMTI+T$DC1I+T$DC2I+T$DC3I+T$PADI,

                                             T$AMTI)) AS DebtorsTransBalCur

FROM

$(RawQVDs)ttfacr200cons.qvd

(qvd)

WHERE TEXT(APPLYMAP('MapFinYearPeriod',num#(text(T$YEAR&num(T$PROD,'00')),'YYYYMM'))) <= $(i)

   GROUP BY COMPANY,

                     T$TTYP&'/'&T$NINV,

                T$ITBP,

                T$CCUR,

                $(i)

;

END IF

NEXT i;