index rebuild/ with(online=on)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » index rebuild/ with(online=on)

index rebuild/ with(online=on)

Rate Topic

Display Mode

Topic Options

Author

Message

webc

Posted Tuesday, November 17, 2009 7:28 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, July 13, 2010 5:27 AM
Points: 14, Visits: 54

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

webc

Posted Tuesday, November 17, 2009 7:52 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, July 13, 2010 5:27 AM
Points: 14, Visits: 54

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

Henrico Bekker

Posted Tuesday, November 17, 2009 10:06 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692

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 »

Permissions