I am testing out SQL Tracing, and I want to generate a trace file that I can load into the Database Engine Tuning Advisor. I have all I need, but not a system with a load that can generate anything in the trace file I am trying to produce. I have a test system set up with the "AdventureWorks2008" test database. Is there a way to emulate stress or strain on it so that I might induce some results in my trace file?
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!