mercredi 18 avril 2018

SQL query Performance testing regarding cache

The situation We are planning to migrate our entire (production)DWH to a new cluster. One of the requirements is that the new cluster is atleast as fast as the current cluster. This calls for performance testing with the current cluster serving as a baseline.

When conducting these tests we want both enviorments to be near identical in terms of behaviour.

I can already clone the user behaviour from the live production cluster and execute it on the new cluster. Leaving the cache to be tackled.

The catch Since we are going to compare this new cluster to the live production enviorment I can't simply clear the cache of both servers. Clearing the cache of the new cluster would be possible since it isn't in production yet. However I am not going to clear the cache of the live production cluster since this is still being used and will have a big impact on the performance.

I was wondering if it would be possible to clone/mimic the cache between the two clusters.

I'm also open for an entire different approach on this matter.

Aucun commentaire:

Enregistrer un commentaire