Should have feedback on missing index, its great know that I have a slow running query but some possible hints on how to improve them.
Should have feedback on missing index, its great know that I have a slow running query but some possible hints on how to improve them,
the infomation is avalible in SQLServer version 2005 onward in the following DMV
sys.dmdbmissingindexdetails
sys.dmdbmissingindexgroupstats
sys.dmdbmissingindexgroups
sys.dmdbmissingindex_columns
So I still have to go off and check.
Overtime as database grow in size and data distribution of the tables changes therefore indexing requirements change, so unless you monitor these DMV's you may not notice that an index may be helpful. Ok not all suggested index should be applied but it can give a DBA a great help in pin pointing what the cause is.
Darryl Hughes
shared this idea
The missing indexes DMVs are not an exact science, so we’ve decided against presenting sometimes-helpful, sometimes-disasterous tuning advice in SQL Monitor.
However I’m confident that SQL Server itself will continue to evolve as a tuning platform, leaving SQL Monitor free to look at the bigger picture.
-
Hi Darryl,
Thanks a lot for your feedback. We will definitely try to improve this.
Thanks,
Priya
