Configure your disk and lun setup for SQL Server

When setting up your server remember to set up a disk partition structure that is meant for SQL server. Just to be clear, you don’t need more than one disk partition to install and get SQL server to run, but if you would like to configure a disk setup that support the internal architecture ofContinue reading “Configure your disk and lun setup for SQL Server”

The Troublesome Heaps

Heap fragmentation is the degree of “out of order extents” and are given by avg_fragmentation_in_percent in sys.dm_db_index_physical_stats. This means that when SQL server allocate pages in bulks of 8 pages per bulk that is called extents. Each page gets a page number and is ordered in the IAM. When a row gets written to aContinue reading “The Troublesome Heaps”

en_USEnglish