Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gsuresh
Starting Member
22 Posts |
 Posted - 2012-11-22 : 08:37:43
|
| How will u tune the index fragmentation?suresh |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2012-11-28 : 06:30:46
|
| 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 |
 |
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-11 : 12:34:46
|
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 RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
|
|
|
sql server 2008