Hi,
I am looking for testing the production database on my close test database. I started exporting the statistics from my production database and imported them to my test database. And now I am looking to go forward to do the performance testing on my test database. I need your expertise in the following scenarios.
1) How to generate large no of user's work load?
2) How to test the queries are using optimal execution plans.
3) As my test Database is smaller than Prod, how can I ensure Test performance will also be optimal on PROD.
Thanks in advance for your help.