Solved

critical components:Fragmentatation Critical

Posted on 2011-02-27
2
340 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 40

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
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.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

718 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