Is your hard drive ready for SQL Server

Back in the age of Windows Server 2003, there was a best practice to align disk partitions for SQL Server for performance gain: http://technet.microsoft.com/en-us/library/dd758814(v=sql.100).aspx

 

This seems old, right? Come on, we are using SQL Server 2014 on Windows Server 2012 R2 now!

 

Well, yesterday I happened to come across this white paper again and wanted to check one of our new servers and guess what – the cluster size on this new box is using default 4096 bytes instead of 64KB which is a best practice:

(Screenshot was taken on my VM, not the actual production server)

I have decided to blog this so I can remind myself in the future – change the cluster size for SQL Server!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s