In SQL Server, missing indexes are indexes that the query optimizer has determined would improve query performance, but do not exist in the database. Identifying and creating missing indexes can improve query performance and help ensure that the database is running efficiently. To find missing indexes in SQL Server, the administrator can use the sys.dm_db_missing_index_details dynamic management view. This view …

How to Find Missing Indexes Read more »

Today I released the August 2019 release of Database Health Monitor. This is version 2.9. My favorite new report is the Blocking By Hour of Day report which uses the existing data that is collected by the historic monitoring feature. Below is a list of some of the things that have been fixed or added in this version and the …

Database Health Monitor – August 2019 Release Read more »

Beta 2 of the Database Health Reports will be available in the next 7 to 10 days as I finish it up. There has been a good acceptance of Beta 1 so far, and with feedback here are some of the things included in the next beta. Overall performance tuning, some of the reports run faster now, and some of …

Working on Beta 2 of the Database Health Reports Read more »