When it comes to indexing, Microsoft has two tools built into SQL Server that can be used to help identify indexes that can improve database performance. These are the missing index Dynamic Management Objects (DMOs) and the Database Engine Tuning Advisor (DTA). Both tools are useful to assist with indexing databases and can provide valuable input when working on tuning a database.
This chapter will explain both indexing tools. We’ll begin by explaining what they are and the capabilities they provide. Then we’ll walk through how the tools can be used to provide assistance with indexing. Throughout the chapter, we will ...