CHAPTER 7
Indexing Tools
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 ...
Get Expert Performance Indexing for SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
