Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server 2008 Database Engine Tuning Advisor

Posted on 2014-02-12
2
Medium Priority
?
333 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
2 Comments
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 2000 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

885 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