October 17, 2013 at 5:06 am
Dear All
Can somebody explain about fragment_count
Regards
October 17, 2013 at 5:22 am
A Fragment is a collection of pages in sequence
For example you can have data spread across 6 pages, but these pages are located in different extents :
Fragment 1 Fragment 2 Fragment 3
page 1, page 2, page 3 page 11, page 12 page 18
Hope this was helpful.
Jonathan Bernardez Bernardez
___________________________________________________________
DBD. MCSA SQL Server 2012
October 17, 2013 at 5:23 am
Read about "Index fragmentation" OR you can more elaborative about this question here to get some specific
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 5:45 am
Hi
Thanks Jonysuise and Bhuvnesh
I was reading about index fragmentation, thats when came across fragment_count. And could no understand the defiantion on the msdn site. So if you can elaborate what it is exactly then it will be great.
What does fragment_count 2000 means? is it in proportion to fragmentation %?
Regards
October 17, 2013 at 5:50 am
fragment count 2000 means that index data is spread accross 2000 blocks of consecutive pages.
Jonathan Bernardez Bernardez
___________________________________________________________
DBD. MCSA SQL Server 2012
October 21, 2013 at 9:47 pm
thanks
October 22, 2013 at 12:48 am
In general, ignore it. It was part of Microsoft's (failed) attempt to simplify the fragmentation information
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply