Solved

SQL Server 2008 Database Engine Tuning Advisor

Posted on 2014-02-12
2
325 Views
Last Modified: 2014-02-14
I regularly use the Database Engine Tuning Advisor to determine what index changes should be made to our SQL Server 2008 database.  I usually add whatever indexes it recommends but lately, along with index additions, it lists indexes that should be dropped.  I must say I'm a little hesitant to start dropping indexes.

Should I follow the recommendations or is there a better tool to use.  I'm a programmer reluctantly performing dba duties and am in need of advice.
0
Comment
Question by:Clinton Smith
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 500 total points
ID: 39853470
it is not always a good practice to follow the tuning advisor blindly..

For example if the tuning advisor suggests you to create 100 different indexes on a table ( hypothetically)... and if you create them, then it will cause an issue in write performance.

It is always a good practice, to create indexes suggested by the tuning advisor and check the performance of the overall system with the benchmark of the performance that is already created before the index is created.

if the index slows down the process then it is better to remove the index and if it increases then you have to consider the size occupied by the index vs performance gain.

There are many other aspects to be considered.
0
 

Author Closing Comment

by:Clinton Smith
ID: 39859928
Thank you.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question