Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

index rebuild/ with(online=on) Expand / Collapse
Author
Message
Posted Tuesday, November 17, 2009 7:28 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 2:28 AM
Points: 14, Visits: 56
when I rebuild index with (online =on ),the avg_fragmentation_in_percent decrease;but,when I rebuild index without use online Options,it can't affect,this confused me for many days ,who can tell me why?

thanks!
Post #820520
Posted Tuesday, November 17, 2009 7:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 2:28 AM
Points: 14, Visits: 56
may be related to the number of rows in the table ?when rows is small,it will not affect,but ,when rows is much ,it will affect.
Post #820526
Posted Tuesday, November 17, 2009 10:06 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 2:39 AM
Points: 1,904, Visits: 2,846
run this first:
=========
DBCC SHOWCONTIG (table_name,index_name)
GO
=========

note the fragmentation and scan density.....

The execute;
==============
DBCC DBREINDEX('table_name',index_name,54)
==============

see any difference in logical frag and extent scan frag?
is your scan density = 100% ?
is your "Avg Pages per extend = 8" ?


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #820557
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse