I believe for any performance investigation you need to have a scenario. Something which is believable and real world like. In my opinion scenarios drive requirements and design.
I want to have a workload which I can use to test and demonstrate various capabilities of SQL Server database. Why I am doing it you may ask? Over the years SQL Server has grown to be such a huge product that it is impossible to keep track of all the things you can do with it. There are tons of books, online articles, white papers, suggestions, tips for getting best performance out of SQL Server. Most of these are very disjointed and keeping track of them is proving impossible for me. So what I want to do is to start with one system and see how these scenarios apply to this system and what should be done to get the best of SQL Server.
I am going to start with "a" workload and start testing various suggestions on it. See how well these suggestions apply to this workload.
Here are the requirements of the workload off the top of my head -
Other requirements that are good to have but not necessary a deal breaker are -
What do you guys think the requirements of this workload should be? Anything else comes to mind?
If there is anything already available like this please point me to it.