<div>
Read up on &quot;Reorganizing and Rebuilding Indexes&quot; in SQL Server BOL.
</div>


Read up on "Reorganizing and Rebuilding Indexes" in SQL Server BOL.

<div>
That table stores historic data?<br />
If so you should think in partitioning table.<br />
Good luck
</div>


That table stores historic data?
If so you should think in partitioning table.
Good luck

<div>
<div class="content wysiwyg-content">
We have a large SQL database (grows 200gb) per month. 95% of the rows are in a single table.<br />
<br />
This table has 1 clustered index and 5 non-clustered indices.<br />
<br />
I am looking for recommendations on the following...<br />
<br />
1. What is the best command to view the current fragmentation level of each index?<br />
<br />
2. What level of fragmentation is generally considered acceptable?<br />
<br />
3. What is the best approach to reduce fragmentation? Rebuild/ reorganize<br />
<br />
Note: we have SQL enterprise and have maintenances windows available on the weekend.<br />
<br />
Thanks<br />

</div>
</div>


We have a large SQL database (grows 200gb) per month. 95% of the rows are in a single table.

This table has 1 clustered index and 5 non-clustered indices.

I am looking for recommendations on the following...

1. What is the best command to view the current fragmentation level of each index?

2. What level of fragmentation is generally considered acceptable?

3. What is the best approach to reduce fragmentation? Rebuild/ reorganize

Note: we have SQL enterprise and have maintenances windows available on the weekend.

Thanks


SQL fragmentation

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.