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 |
|
rajemessage
Starting Member
17 Posts |
 Posted - 2013-12-14 : 08:46:53
|
| Hi,I have pk and fk in the database , i want to find out where i can make some good indexes.(sqlserver 2005)Questions1) Is there any dmv which can help me in finding out where should i make indexs?2) What counter i should use in profiler to find the above ?3) If any other tool is availabe please tel me.yours sincerely |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-14 : 10:34:22
|
| 1. You can run the query with show execution plan option ON in SQL management studio and it will suggest you missing index information http://technet.microsoft.com/en-us/library/ms345417(v=sql.90).aspx2. Another option is to use database tuning advisorhttp://technet.microsoft.com/en-us/library/ms173494(v=sql.105).aspx3. Another method is to use info from dmvs like sys.dm_db_missing_index_detailshttp://www.mssqltips.com/sqlservertip/1634/using-sql-server-dmvs-to-identify-missing-indexes/------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
rajemessage
Starting Member
17 Posts |
Posted - 2013-12-16 : 02:50:19
|
| Hi, Database Engine Tuning Advisor uses trace files, trace tables, Transact-SQL scripts, or XML files as workload input when tuning databases.please tel me which one i should prefer, like providing query as input or using profiler trace.why i am asking is, i noticed in the case of statistic it considers some samples not the full table.So please tel me which technique will be more accurate for identification of indexs?like queries or trace etc.If i can get pros and cons of each type of input to database engine tuning advisor then that would be help full?yours sincerely. |
|
|
|
|
|
|
How to find where one can make good index