Skip to Content
0
Former Member
May 16, 2016 at 01:02 PM

Same query on different machines - performance difference

18 Views

Hello,

We are running SQL on top of calculation view.

In our QA system it runs for 6 minutes and consume 88GB while the very same query runs on PROD for 3 seconds and consume less than 1 GB!!!

The table sizes in QA are much smaller than PROD. The table partition is also different. QA has 1 node of 0.5 TB while prod has 4 nodes of 0.5 TB.

What can be the cause for such a big different between the environments?

Thanks,

Amir