I am measuring the performance of a query execution in a test environment and i have a following scenario..... This test environment has data volume equivalent to production environment, but its hardware is downsized compared to production environment, i.e., its 40% or 50% of production environment or configuration.
Can anyone please help me to understand on, how to compare or measure the performance of the query execution between this test environment and production environment ??? What all are the list of factors that i need to consider to consider in this scenario for comparision ?