Dynamics Ax Performance Tuning with Missing Indexes

If you want to do Dynamics Ax Performance Tuning with Missing Indexes then this link is useful for you to get missing indexes, used and unused columns.


dynamic axapta

This important query details mentioned on that links.

select d.*
 , s.avg_total_user_cost
 , s.avg_user_impact
 , s.last_user_seek
 ,s.unique_compiles
from sys.dm_db_missing_index_group_stats s
 ,sys.dm_db_missing_index_groups g
 ,sys.dm_db_missing_index_details d
where s.group_handle = g.index_group_handle
and d.index_handle = g.index_handle
order by s.avg_user_impact desc