November 12, 2009 at 7:01 am
1. Why do we need to create the workload file.
2. For the fresh database which is not yet tunned with DTA, what should contain in workload file.
I can do this by using the TRACE file data or by writting some bacth statments. How it will help DTA for recommendations.
Abhijit - http://abhijitmore.wordpress.com
November 12, 2009 at 7:33 am
You need it to give the DTA something to work from, IE - how else would it know where to improve performance if it doesn't know what the current performance is?!
You'll need to gather a days worth of activity (or at least a few hours) by using the Tuning template when creating a trace file in SQL Profiler. Defaults should be fine to get you started. Use that file as input for the DTA and see what it brings back.
Be sure you know of the performance overhead of running a trace on a production server. Ideally done on your dev server.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply