November 5, 2008 at 10:15 am
As I'm doing some housekeeping/monitoring of one of our databases I've noticed, using dm_db_index_physical_stats, that there is a significant amount of index fragmentation being reported on some of the branch/intermediate index nodes. The leaf leaf nodes are fine (as far as reported fragmentation goes)
I've tried to Reorg/Rebuild the a couple of these intermediate-level index nodes (using Alter Index...) but it doesn't appear to have any substantial affect.
Do I need to be concerned with high degrees of reported fragmentation on these branch index levels and, if so, what's the best practice (advice) for handling them?
Thanks
Glenn
November 5, 2008 at 10:28 am
what's the size of your indexes (pages) ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 5, 2008 at 10:42 am
An example of one of the tables that I'm looking at as 2 indexes:
index_level avg_fragmentation frag_count avg_frag_size_in_pages page_count rec_count
idx#1 1 of 3 97.297 37 1 37 16251
idx#2 1 of 3 94.594 74 1 74 16250
Thanks
November 6, 2008 at 1:32 pm
can you run sp_updatestistics and dbcc updateusage(0) with count_rows ?
This should get you fresh stats ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply