• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 144
  • Last Modified:

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?
0
itnifl
Asked:
itnifl
1 Solution
 
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
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
0
 
itniflAuthor Commented:
Thank you.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now