O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

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

Implementing sustainable index maintenance practices for a VLDB & 24/7 environment

The index maintenance is one of the optimizing applications steps, and implementing sustainable index maintenance for a VLDB environment should be evaluated from several different perspectives. There are many cases for any performance hit will see on the databases, next to not having indexes or indexes that are very fragmented. Also, the issue will be multi-fold where fragmented indexes will take more space than to maintain the indexes alone impacting on all aspects of the database activities.

In this recipe, we will go through the strategy of implementing sustainable index maintenance practices for a very large database, and a database environment that must be available ...

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