<div>
Read through, this may help you<br />
<a href="http://msdn.microsoft.com/en-us/library/ms177571.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms177571.aspx</a>
</div>


Read through, this may help you
http://msdn.microsoft.com/en-us/library/ms177571.aspx [http://msdn.microsoft.com/en-us/library/ms177571.aspx]

<div>
Thank you for a direct answer. &nbsp;I have read the article pointed out by the other response, but it did not give me the threshold value.
</div>


Thank you for a direct answer.  I have read the article pointed out by the other response, but it did not give me the threshold value.

<div>
<div class="content wysiwyg-content">
I have DBs that have indexes that are fragmented in various levels from 30% to 99% because index maintenance was never scheduled/ created. &nbsp;I know that it is easier to INDEXDEFRAG than to Rebuild the INDEX (Less time and no long term locks on the table), but there must me a specific point where rebuilding would be better than tryig to defrag the index. &nbsp;(I know that rebuilding would need to be done in non-production hours or late at night). &nbsp;But I want to set up a process that checks the fragmentation of an index and if the %of fragmentations is over a specific amount, set that index for rebuilding and if it is less than a specifi % set the index for defraging. &nbsp; Does anyone have an idea where / what that % might be? &nbsp;(Lets use a simple index of one column with 500K records as an example).<br />
<br />
Thanks in advance
</div>
</div>


I have DBs that have indexes that are fragmented in various levels from 30% to 99% because index maintenance was never scheduled/ created.  I know that it is easier to INDEXDEFRAG than to Rebuild the INDEX (Less time and no long term locks on the table), but there must me a specific point where rebuilding would be better than tryig to defrag the index.  (I know that rebuilding would need to be done in non-production hours or late at night).  But I want to set up a process that checks the fragmentation of an index and if the %of fragmentations is over a specific amount, set that index for rebuilding and if it is less than a specifi % set the index for defraging.   Does anyone have an idea where / what that % might be?  (Lets use a simple index of one column with 500K records as an example).

Thanks in advance

Index Rebuild or Index Defrag?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.