|
-
 Originally Posted by Thomas7
1) How to generate large no of user's work load?
Look for a workload generator/simulator. Plenty of offer.
Originally Posted by Thomas7
2) How to test the queries are using optimal execution plans.
Looking at them, one at a time.
Originally Posted by Thomas7
3) As my test Database is smaller than Prod, how can I ensure Test performance will also be optimal on PROD.
You can't.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote