0

I have run the Database Engines Tuning Advisor in Sql Server 2008 R2, then there are a few indexes that it suggested me to create, so I created them. The question is, in what way that I can check if these indexes are helping the DB performance ? Thank you.

Improve this question

1 Answer 1

Reset to default
1

Try running an explain plan on the queries that are performed in your application. They should show a relatively low query cost.

You could drop the indexes again, run the original explain plan statements to compare the performance before and after adding the index.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

That actually came naturally when I was thinking how to do it and now I can confirm. Since I am not a DBA, I was just wondering was there any other ways how people do this. Thank you:)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.