| Author |
Topic |
|
swekik
Posting Yak Master
126 Posts |
 Posted - 2008-08-28 : 13:29:51
|
| Can any body tell me what are the acceptable values for the fragmentation??I know abt the scan density,which has to be >=80%Wht are the other acceptable values like 1.Logical scan Fragmentation?2.Extent Scan Fragmentation? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-28 : 13:41:05
|
quote:
Originally posted by swekik
Can any body tell me what are the acceptable values for the fragmentation??I know abt the scan density,which has to be >=80% >95% betterWht are the other acceptable values like 1.Logical scan Fragmentation? 0 or closer to it is better2.Extent Scan Fragmentation? 0 or closer to it is better
|
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-08-28 : 15:28:34
|
| Is it for 2005 Tkizer? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-08-28 : 15:34:35
|
| I mean the new version which is coming out next week. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-08-28 : 17:39:54
|
| Tara,Nice script. We have 2 scripts right now that we run. One is for indexes w/o LOB data and the other is for indexes with LOB data (I inherited it this way!). I think yours is more robust since it accounts for scenarios ours does not. Even though we don't use those features yet I see no harm in preparing for the day we do.But aside from that, what type of schedule do you find yourself running this script on? From prior conversations I know you deal with databases much larger than what we have, but our databases are extremely busy. I'd like to gauge your activity/rebuild schedule against mine since I very well might borrow your code (if you have no objections that is!). |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Ola Hallengren
Starting Member
33 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Fragmentation