Viewing 15 posts - 211 through 225 (of 242 total)
I take Gails point but I'd still say rebuild those indexes at greater than 30% fragmentation even if less than 1000 pages. This won't make a huge difference though either...
March 18, 2009 at 7:50 am
GilaMonster (3/18/2009)
Tim Walker (3/18/2009)
March 18, 2009 at 4:48 am
GilaMonster (3/18/2009)
Tim Walker (3/17/2009)
GilaMonster (3/17/2009)
The usual rule-of-thumb is 1000 pages to a table/index before you needs to worry about fragmentation.
This is a common view but I don't agree, I think...
March 18, 2009 at 3:00 am
GilaMonster (3/17/2009)
The usual rule-of-thumb is 1000 pages to a table/index before you needs to worry about fragmentation.
This is a common view but I don't agree, I think 64-ish pages is...
March 17, 2009 at 5:35 pm
I'm afraid I'm with Adi Cohn, it's much more complex than your reply suggests.
Although there are theoretical approaches you can take to this, I find the best bet is to...
March 17, 2009 at 7:04 am
Krishna (3/17/2009)
As a genral rule of thumb Fillfactor should be:100% for no activity
90% for low activity
70% for medium activity
50% for higher activity or more
I'm not sure you can have a...
March 17, 2009 at 6:53 am
I think the reason that very small tables don't appear to defrag is that normally the first 8 pages are always in mixed extents so appear in eight different extents.
So...
March 13, 2009 at 9:13 am
Dave,
OK .. I can see how you know how many updates.
Sorry about the schema point .. My mistake in misreading what you did!
To see whether a shrink has occurred in...
March 12, 2009 at 8:31 am
Dave,
There is something in your figures I still can't understand here. You are right, they don't stack up.
How do you know you are updating only a few hundred rows? You...
March 12, 2009 at 5:38 am
Dave Mason (3/10/2009)
GilaMonster (3/10/2009)
Dave Mason (3/10/2009)
Oh, as far as the fragmentation threshold goes, it was 3% (or more) this morning. Prior to that, it was 5%.
I wouldn't worry until...
March 11, 2009 at 3:19 am
Mohit (3/11/2009)
I had dealt with system where they have very wide cluster keys (I am not allowed to...
March 11, 2009 at 3:13 am
I like the way this thread has developed because my objective is to be able to find authorititive material rather than to feel I'm a member of a group of...
March 10, 2009 at 6:45 pm
Richard answer sounds 100% (or 100MB) correct to me!
March 10, 2009 at 6:12 pm
The trigger need not be on this table, of course ...
March 10, 2009 at 6:02 pm
I'm with you. this doesn't seem right. I can't see how so few updates could result in so much fragmentation.
Assuming your stats are correct, could a badly behaved trigger be...
March 10, 2009 at 5:57 pm
Viewing 15 posts - 211 through 225 (of 242 total)