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 |
|
alecl
Starting Member
13 Posts |
 Posted - 2002-06-13 : 11:46:05
|
| I like to turn on the trace and then run the trace file through the index wizard to see if it comes up with anything I may have missed (it's a rather large site with a ton of queries and SP's).I'm running into a couple of issues with my SPs though. If I do a trace and run a few SPs, the wizard complains it has no data to work with. I looked at the trace files and they are truncating the longer SQL statements in the SPs so I think that may be the problem. But I'm also wondering if I need to turn on any other options in the profiler to store the proper information for the wizard.Any ideas? |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-06-13 : 12:00:45
|
quote:
If you do not have an existing workload for the Index Tuning Wizard to analyze, you can create one using SQL Server Profiler. Either create a workload using the Sample 1 - TSQL trace definition or create a new trace that captures the default events and data columns.--books on line
I'm not a big fan of wizards because they abstract out the theory of these tuning exercises and you are at the mercy of an automated process that may not truely understand your business rules. . . but to each his own.<O> |
 |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-06-13 : 12:08:53
|
| Go into trace properties and under the events tab choose all the stored proc options and all the tsql ones. Then from there filter out the ones don't really have any relivance to what your tracking. With all tsql transactions and all SP's your bound to get some data... Should give you a little more insight. Start big and filter to smaller from thereProfiler wizard is not your best bet (If I remember right, even microsoft agrees on this one). Just open it up, choose new trace and goto the event tab.-----------------------The best answer = just do as rob or page47 say. |
|
|
|
|
|
|
Profiling Stored Procedures