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 |
|
MikeZ
Starting Member
6 Posts |
 Posted - 2014-07-10 : 21:34:21
|
| Hi All, At the moment I am tuning the indexes with high fragmentation ..I created a maintenance plan for rebuild /reorganize ( set the logic for fragmentation above 50% then I will do rebuild , otherwise I will reorganize ... fill factor = 80 . I also filtered by the number of page count. noticed there is 1 index which is fragmented very quickly starting from 2 am until 7 am .I did rebuild / reorganize every 2 am ( after log backup at 12 am) I believe after rebuild it will become 0% but after 3 hours it will become 80% I guess...I check the unused index data ( using the script ) and for that index i got this data :User_Seek : 0User_Scans : 16User_lookup : 0User_updates : 1.128.932I wonder that I should just drop this index or keep maintain it with rebuild it AGAIN after a few hours later ...Please kindly advice...thanks heapsCheers,Me |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-11 : 12:06:17
|
| Is the fragmentation causing performance issues? If it isn't, and it likely isn't, then just reorg/rebuild it as per your normal index maintenance schedule. How many rows are in this table? How many pages are in the index?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
High Fragmentation Indexes