O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

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

Determining disk space consumed by indexes

Performance tuning is part of a DBA's job; at the same time, the DBA also has to take care of the SQL Server instance, the amount of disk space consumed by database(s), providing high availability to the database users, managing database backup/restore policy as a part of disaster management, and a lot more.

Out of these listed responsibilities, disk management is also one of the important tasks to manage. The DBA needs to keep a watch on it and claim any free space consumed by unused indexes, manage the size of log files and data files, and arrange for a larger-sized disk, if needed.

In Chapter 9, and in this chapter, we have discussed many times that an index comes with some overhead, and one of the ...

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