I captured the workload from an existing server and want to replay from that workload to load test a new server and database. This workload contains significant number of update and insert statements. If I run the workload with concurrent userload of (let's say 100 users), it creates database locking and deadlocks, producing unrealistic testing results.
Should I clean up this workload to remove all update and insert statements before I run it in BMF?
Is that the right thing to do knowing that by removing a lot of the statements, I will be altering the real workload.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center