This is something that came up recently on the Microsoft Certified Master DL, and is something I discuss in our IEPTO1 class because of the performance implications of it, so I thought it would make an interesting post. Allocation Algorithms The SQL Server Storage Engine (SE) uses two algorithms when allocating extents from files in [&]

The post Investigating the proportional fill algorithm appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/txELcA4VVYM/