September 29, 2009 at 5:09 am
Hi All,
What may be the cause for indexes getting fragmented quickly?
September 29, 2009 at 5:21 am
manohar-718845 (9/29/2009)
Hi All,What may be the cause for indexes getting fragmented quickly?
Multiple reasons, Shrinking the database, and lots of inserts and updates can have an effect on fragmentation.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 29, 2009 at 7:54 am
...and too high a fill factor
September 29, 2009 at 8:48 am
What's quickly? What have you measured? What is the load on the db over that time? How many insert/update/deletes?
September 29, 2009 at 10:04 pm
Through DBCC ShowContig I checked the logical fragmentation and also using DMV query to measure the index fragmentation.
Database load is around 150 to 200 users.
As I see there are no huge number of inserts and updates, normal inserts and updates are happening.
Around 10 to 15 tables I have created three or four indexes as these tables are frequently used in selecting the data. For these tables, data will be inserted in there is no load on database, we have written windows service for this.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply