TriCore Blog SQL Server Performance Troubleshooting – Missing Indexes

Posted By: Bob Lane As DBA’s it is not unheard of to hear that “an application running slow” . When a particular query can be identified, the Database Engine Tuning Advisor can be used to look into the query plan. However, many a times the users don’t have the visibility into what is being run. This is where the DMVs can be extremely useful in identifying the most important missing indexes.