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 ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook 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.
