• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 573
  • Last Modified:

prevent Index Fragmentation.

experts,

In an OLTP database (with a large number of inserts) what would be best and easiest action to prevent Index Fragmentation.

Thanks,

Lynn
0
yrcdba7
Asked:
yrcdba7
1 Solution
 
lluddenCommented:
You need to determine why the fragmentation is happening.  Is it on every index or just a few?  You can reduce your Fill Factor to slow down the fragmentation rate, but it will still occur.  You can schedule maintenance jobs to rebuild your indexes.

Indexes on some data types (GUID) tend to fragment more easily.
0
 
Anthony PerkinsCommented:
>>what would be best and easiest action to prevent Index Fragmentation<<
Short answer:  You cannot.  Long(er) answer the best you can do is minimize fragmentation by choosing appropriate indexes and doing regular maintenance.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now