<div>
This is a good article to read through to understand fragmentation and how to fix it. Keep in mind this is a multi-page article - the &quot;Next Page&quot; isn't very visible compared to the rest of the page.<br />
<br />
<a href="http://www.sql-server-performance.com/articles/per/Analyze_and_Fix_Index_Fragmentation_in_SQL_Server_2008_p1.aspx" rel="ugc">http://www.sql-server-performance.com/articles/per/Analyze_and_Fix_Index_Fragmentation_in_SQL_Server_2008_p1.aspx</a><br />
<br />

</div>


This is a good article to read through to understand fragmentation and how to fix it. Keep in mind this is a multi-page article - the "Next Page" isn't very visible compared to the rest of the page.

http://www.sql-server-performance.com/articles/per/Analyze_and_Fix_Index_Fragmentation_in_SQL_Server_2008_p1.aspx [http://www.sql-server-performance.com/articles/per/Analyze_and_Fix_Index_Fragmentation_in_SQL_Server_2008_p1.aspx]



<div>
<div class="content wysiwyg-content">
Hei!<br />
&nbsp; i am getting the following error on my production DB, which is an Datamart.<br />
<br />
&quot;critical components:Fragmentatation<wbr /> Critical&quot;<br />
<br />
What do i do?<br />
<br />
//shanj
</div>
</div>


Hei!
  i am getting the following error on my production DB, which is an Datamart.

"critical components:Fragmentatation Critical"

What do i do?

//shanj

critical components:Fragmentatation Critical

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.