SQL Server performance is critical for business applications to meet internal and external customer needs. Unfortunately, one of the most common SQL Server performance issues is related to missing or incorrect indexes. This situation can cause excessive I/O and CPU overutilization, and it can even lead to additional memory usage. Microsoft® SQL Server® is relatively unique because, as a database engine, it records missing indexes it thinks will help queries.
In this whitepaper, we’ll dive into the following: