We have newly installed Fast track Server for SQL Server 2008 R2.
I have created a table with partition function and scheme. I am loading data "Contiguously" to the table like "Order by Pk_Column option(MAXDOP 1). So the data getting loaded, but when I check the fragment values at the
table , I am getting low numbers for the avg_fragment_size_in_pages column. As microsoft recommed that this column value should be more than 400 means, good numbers and performance also will be good other wise low performance.
when you look at
sys.dm_db_index_physical_stats, a high value number for fragment_count or a low value for
avg_fragment_size_in_pages can indicate lack of contiguousness.
View Complete Post