SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Index Tuning Wizard
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

maya_zakry
Constraint Violating Yak Guru

Malaysia
379 Posts

Posted - 04/17/2007 :  21:22:37  Show Profile  Click to see maya_zakry's MSN Messenger address  Send maya_zakry a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
2507 Posts

Posted - 04/17/2007 :  22:06:06  Show Profile  Visit dinakar's Homepage  Reply with Quote
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/
Go to Top of Page

maya_zakry
Constraint Violating Yak Guru

Malaysia
379 Posts

Posted - 04/17/2007 :  23:04:10  Show Profile  Click to see maya_zakry's MSN Messenger address  Send maya_zakry a Yahoo! Message  Reply with Quote
would u mind to explain indexing as simple as possible? couldnt understand topic 'Index Tuning Wizard' in BOL

~~~Focus on problem, not solution~~~
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 04/19/2007 :  03:45:39  Show Profile  Reply with Quote
"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
Go to Top of Page

SatyaSKJ
Starting Member

United Kingdom
46 Posts

Posted - 04/19/2007 :  06:47:17  Show Profile  Visit SatyaSKJ's Homepage  Send SatyaSKJ a Yahoo! Message  Reply with Quote
http://www.sql-server-performance.com/index_tuning_wizard_tips.asp
http://www.sql-server-performance.com/nb_index_wizard.asp
http://support.microsoft.com/kb/832526

Satya SKJ
SQL Server MVP
http://www.sqlserver-qa.net
Go to Top of Page

jporter892
Starting Member

USA
1 Posts

Posted - 09/12/2013 :  22:50:48  Show Profile  Reply with Quote
Heres a good reference on indexes:

http://www.programmerinterview.com/index.php/database-sql/what-is-an-index/

and another good one on improving index performance:

http://www.programmerinterview.com/index.php/database-sql/sql-index-performance/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000