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 |
|
maya_zakry
Constraint Violating Yak Guru
379 Posts |
 Posted - 2007-04-17 : 21:22:37
|
| hi all,jusr read about index tuning wizard in BOL.. not sure about it enuff.. can anybody explain in what scenario we should use this wizard/~~~Focus on problem, not solution~~~ |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-04-17 : 22:06:06
|
| To identify any potential indexes might help, or to identify indexes that you have that are not being used..etc************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
maya_zakry
Constraint Violating Yak Guru
379 Posts |
Posted - 2007-04-17 : 23:04:10
|
| would u mind to explain indexing as simple as possible? couldnt understand topic 'Index Tuning Wizard' in BOL~~~Focus on problem, not solution~~~ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-19 : 03:45:39
|
| "couldnt understand topic 'Index Tuning Wizard' in BOL"Me neither, the first time I read it!You use SQL Profiler to record all the queries on your system over a "representative" period of use.Then at some convenient time (e.g. when the system is quiet!) you process that Profile Log with Index Tuner. There are various settings you can select - such as how "complex" you want the Wizard to consider making your indexes, and whether you are happy that it considers dripping existing indexes.It churs away (probably for HOURS!! on a log from a reasonably busy system) and then advises on Indexes to create, plus it provides a bunch of reports on why/how/etc.You then decide which indexes you would like to make (or you let Index Wizard just create them for you, but I reckon that's way too scary!)Kristen |
|
|
|
SatyaSKJ
Starting Member
46 Posts |
|
|
jporter892
Starting Member
1 Post |
|
|
|
|
|
Index Tuning Wizard