Hi All,
Is there a way to tell at what level the index pages are fragmented ? is it leaf level or intermediate levels of the index is fragmented? just a side note, does sys.dm_db_index_physical_stats () show us leaf level fragmentation or does it shows intermediate level fragementation as well? if so, what are the output columns from sys.dm_db_index_physical_stats I can check? Basically, I want to check whether page splits/fragmentation is happening at leaf level pages of the index or intermediate pages.
Thanks,
'Sam
check the "mode" parameter of the sys.dm_db_physical_stats function
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply