![]() The above article contains a script the will rebuild/reorg indexes above 10% fragmented on just the current database. This is a sql script I wrote based off this MSDN article : There is a lot more to it, but that should give you an idea. When that happens, a read or search has to jump around the database to retrieve the requested data. So an insert needs to find some free space, or, an update (or delete) might overflow the previous space used for that data and needs to find somewhere else to put the data.Īs more data is needing to use (or creates) non-contiguous space, then it can cause fragmentation. Ideally that space is contiguous, but sometimes it isnt. ![]() ![]() Very simply put, as data is being written to the database, it needs to find free space to write (or replace) that data into. Index Fragmentation can be a major factor in performance degradation. ![]()
0 Comments
Leave a Reply. |