Missing Indexes

Question

Missing Indexes

pankaj.kuchaliya

SSC Eights!

Points: 944
More actions
September 20, 2010 at 3:01 am

#387825

Hi,
I fire the query "select * from sys.dm_db_missing_index_details " , i see there are lots of indexes.
Is there any performances issues due to missing indexes. and should i remove these or not.
Please Help.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

pankaj.kuchaliya (9/20/2010)
I fire the query "select * from sys.dm_db_missing_index_details " , i see there are lots of indexes.

You should not blinding trust this information. this is not helpful or relevant always.

pankaj.kuchaliya (9/20/2010)
Is there any performances issues due to missing indexes. and should i remove these or not.

Missing or lack of indexes always a big problem for performance.but main question is:

Did you find any performance issue in any migration/SP/script ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

pankaj.kuchaliya SSC Eights! Points: 944 More actions · Answer 2

Bhuvnesh (9/20/2010)
pankaj.kuchaliya (9/20/2010)
I fire the query "select * from sys.dm_db_missing_index_details " , i see there are lots of indexes.
You should not blinding trust this information. this is not helpful or relevant always.
pankaj.kuchaliya (9/20/2010)
Is there any performances issues due to missing indexes. and should i remove these or not.
Missing or lack of indexes always a big problem for performance.but main question is:
Did you find any performance issue in any migration/SP/script ?

thanks for reply,

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 3

Pankaj,

Refer below link, you will get better idea about this http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/c7c55964-eb9a-4fa2-829c-f75e8a455189

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Jack Corbett SSC Guru Points: 184394 More actions · Answer 4

Bhuvnesh is correct in saying that you should not just blindly implement these indexes. You need to know which indexes you currently have that are not being used and you need to take into account the impact adding indexes will have on inserted, updates and deletes.

I'd recommend going through the blog posts listed here.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

pankaj.kuchaliya SSC Eights! Points: 944 More actions · Answer 5

Jack Corbett (9/20/2010)
Bhuvnesh is correct in saying that you should not just blindly implement these indexes. You need to know which indexes you currently have that are not being used and you need to take into account the impact adding indexes will have on inserted, updates and deletes.
I'd recommend going through the blog posts listed here.

Hi,

i will thoroughly check which index need to be created or not.

thanks for reply