O'Reilly logo

Expert Performance Indexing for SQL Server 2012 by Ted Krueger, Jason Strate

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 7

image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required