My current skillset lies towards plain vanilla data warehousing, with < 20k users, our setups are rather simple..

I am looking for ways to enhance my technical skills, however, as much theory as I read, I'm struggling to figure out how I can actually generate workloads of 100k+ transactions/second , or 10k users hitting a report from different parts of the world.

How do people normally gain expertise in large scale database systems outside of what they do at work? (I have a MSDN subscription, so $150/month on Azure to play with)

closed as off-topic by Mark Storey-Smith, Paul White, ypercubeᵀᴹ, RolandoMySQLDBA, Max Vernon Oct 19 '14 at 23:38

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Mark Storey-Smith, Paul White, ypercubeᵀᴹ, RolandoMySQLDBA, Max Vernon
If this question can be reworded to fit the rules in the help center, please edit the question.


I think the TPC-H benchmark (or TPC-DS) might be a good start. The council publishes the tool to generate data and the workload.

Not the answer you're looking for? Browse other questions tagged or ask your own question.