February 11, 2010 at 6:58 pm
We have a table that has 323021 records
it has a Data space of 44.5 MB's
it has 4 indexes
it's largest field is like varchar(1000)
we perform about 2000 inserts and about 300 updates a day on this table
for some reason a couple of the indexes on it keep getting up to over 50 percent fragmentation after like 12 hours and it starts to cause massive slow down on queries based around seeks on these indexes...
So we've had to update our maintenance plan to reorganize indexes every like 10 hours in order for the whole system to not slow to a crawl...
Is that normal?
Or are we just catering to the symptoms of a much larger issue?
February 11, 2010 at 8:16 pm
Please provide table structure. This will help isolate the cause of your fragmentation.
Also, knowing your process for performing the inserts would be helpful. The cause is likely a combination of those two factors.
With your table structure provide the index definitions (clustered and nonclustered).
This should not be normal behavior but could be expected depending on design.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2010 at 3:51 am
The amount of fragmentation depends on the table and indexes (clustered or not) structure.
Kimberly Tripp's blog on sqlskills.com offers plenty of detail.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply