Solved

critical components:Fragmentatation Critical

Posted on 2011-02-27
2
335 Views
Last Modified: 2012-08-14
Hei!
  i am getting the following error on my production DB, which is an Datamart.

"critical components:Fragmentatation Critical"

What do i do?

//shanj
0
Comment
Question by:shanj
2 Comments
 
LVL 15

Expert Comment

by:derekkromm
ID: 34994814
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

0
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 34997902
I would use Microsoft own where they give you code sample how to detect it and how to REBUILD the fragmented index:

http://msdn.microsoft.com/en-us/library/ms189858.aspx

Just keep in mind you would want to do that with option ONLINE = ON on live production databases because your queries will run slow due to locking/blocking.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now