Run stress against AdventureWorks2008 database

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?
LVL 2
itniflAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Marten RuneConnect With a Mentor SQL Expert/Infrastructure ArchitectCommented:
0
 
DcpKingCommented:
Try writing a test procedure that runs some of the procs in AdventureWorks. For example, run uspGetBillOfMaterials for each ProductAssemblyID in Production.BillOfMaterials.


hth

Mike
0
 
itniflAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.