-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Ryan Adams

Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud. Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.

Archives: June 2018

Verify Allocation Unit Size for SQL Server

Why Do I Care? Everything in SQL Server is stored on disk in 8K pages.  The Microsoft recommended best practice is to format using a 64K allocation unit size.  Processes such as the checkpoint and Lazy Writer try to write in extents when possible.  Extents are a collection of 8… Read more

10 comments, 476 reads

Posted in Ryan Adams on 19 June 2018

Verify Allocation Unit Size for SQL Server

Why Do I Care? Everything in SQL Server is stored on disk in 8K pages.  The Microsoft recommended best practice is to format using a 64K allocation unit size.  Processes such as the checkpoint and Lazy Writer try to write in extents when possible.  Extents are a collection of 8… Read more

0 comments, 63 reads

Posted in Ryan Adams on 19 June 2018