Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
 Posted - 2002-10-02 : 13:57:12
|
I would like to create a trace to be used to create a sample workload for the Index Tuning Wizard. This is for a SQL 7 environment. I have a couple questions.1.) If I capture SQL:BatchCompleted and RPC:Completed events and only the Event Class, Text, ObjectID and StartTime columns, with a app filter on Profiler, will this be enough info for the wizard?2.) If I run this trace without a db filter, how will the wizard know which database the proc or batch was run in? Or does the wizard only run against one database at a time?3.) I'd like to run the trace info into a table on my server. I assume xp_trace_setqueuedestination is the correct proc for this, but something in BOL confuses me ...quote:
If sending to a table, be sure to set the application parameter of xp_trace_generate_event; otherwise, no data is added to the destination table.-SQL Sever 7 Books Online "xp_trace_setqueuedestination" ... description of destination argument
What does that mean? Does that mean I need to capture the application column in my bitmask supplied to xp_trace_addnewqueue for it to write to a table?Thanks for any insite ...Jay White{0} |
|
|
|
|
|
xp_trace_addnewqueque