SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 sql server 2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gsuresh
Starting Member

India
22 Posts

Posted - 11/22/2012 :  08:37:43  Show Profile  Reply with Quote
How will u tune the index fragmentation?

suresh

srimami
Posting Yak Master

160 Posts

Posted - 11/28/2012 :  06:30:46  Show Profile  Reply with Quote
We cannot tune the Index Fragmentation. Based on the % of fragmentation, either Rebuild or Reorganize.

If the fragmentation is anywhere above 30%, rebuild the Index and anywhere between 10-30, reorganize the Index
Go to Top of Page

sgondesi
Posting Yak Master

India
193 Posts

Posted - 11/11/2013 :  12:34:46  Show Profile  Reply with Quote
quote:
Originally posted by srimami

We cannot tune the Index Fragmentation. Based on the % of fragmentation, either Rebuild or Reorganize.

If the fragmentation is anywhere above 30%, rebuild the Index and anywhere between 10-30, reorganize the Index



Hai. I am srikar.

how to check the index fragmentation?

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000