rebuild index

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Thomas LeBlanc SSCrazy Eights Points: 8085 More actions · Answer 1

reindexing in our shop depends on the application and database size.

Some are re-indexed every night, when there are no users on the system.

But the large databases (200+ GB with 40-50 GB tables, one with 17 indexes) are not reindexed until our once a month maintenance windows.

There is also the function(dmv) of looking at fragmentation on an index or clustered table and determining from that when to index.

We also use Diagnostic manager for this fragmentation, and reindexing from their tool.

God Bless,

Thomas

Thomas LeBlanc, MVP Data Platform Consultant

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 2

Good one to read once:

HTH,

MJ