Load performance on Windows 2012

jarno_loubser — Thu, 25 Jul 2013 07:19:24 GMT

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;

topic Load performance on Windows 2012 in QlikView

Load performance on Windows 2012