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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-25 : 10:37:59
|
| Badarinarayan N writes "Hi, every one.I want to know how to make index tuning using index tuning wizard.In that using 2nd option sql server tracs table without losting of records or data which that particular table comprises.so if any one know plz inform me. thanking you" |
|
|
jhnegrao
Yak Posting Veteran
81 Posts |
Posted - 2006-08-25 : 16:33:04
|
| Hello, You need to use SQL Profiler to trace the transactions in your server. Save this trace to a file and after that, you will use this file as input to your index tuning wizard. |
 |
|
|
|
|
|
Index tuning