How Do We Use Tuning In Sql Server?can You Give An Example?
The correct configuration and tuning of the server is very important, otherwise even expensive server hardware won’t perform well. By using indexes on database tables, you can greatly enhance the performance of your server. The SQL server has a tool known as the Index Tuning wizard for this purpose. After identifying the activity whose performance you want to optimize, you can start the index tuning from using the Enterprise manager. This will tell you how much improvement there would be once the changes have been made. You can find more on Indexes and server tuning.
