#Install sql server 2014 on azure server install#

Microsoft recommends enabling TRIM for unmanaged standard disks.Disable caching on transaction log drives.If you’re using SSD drives, the data drives should have read caching.If you still want an antivirus software, make sure that it excludes: I don’t like anti-virus software, and if it doesn’t crash things, chances are that it’ll come with a measurable performance impact.

Name your drives in a sensible manner, like DATA1, DATA2, DATA3, … LOG1, LOG2, … TEMPDB1, TEMPDB2, …, BACKUP, etc.Format all data/log drives using 64 KB block sizes, as this aligns with the I/O operations of SQL Server.Partition your volumes with GPT rather than MBR if you can.Possibly a separate volume for the SQL Server program files.Ideally, place the following on one or multiple volumes each: How many drives you use will depend on how deep pockets you have. Use separate disks for database files, transaction log files, backups and tempdb.* this is true for Database Mail on SQL Server 2016 – I haven’t actually verified this myself on 2017 or 2019. Click the “Manage” button in the top-right corner and select “Add roles and features”. Turns out if you plan on using Database Mail for your SQL Server, you’ll also need to install.

#Install sql server 2014 on azure server install#

NET Framework, but you may have to install it on older Windows Server versions. Windows Server 2016 comes pre-installed with this version of the. I’m using Windows Server 2019 for the examples and screenshots, but I think most of this will work on Windows Server 2012/2012R2 or 2016 as well.

MS Technet has a breakdown of different RAID levels.

Glenn Berry goes through some recommended CPUs for SQL Server on.

To keep this checklist accurate, I’m going to stay firmly in my comfort zone and leave SAN performance, RAID configuration, NIC teaming and load testing to other professionals. As a consultant, I’m typically provided with a fresh server (VM or physical) with a clean install of Windows Server and the basic networking, domain, storage, etc installed and nothing more. This checklist assumes that all your hardware is in place and tested.

Starting with 2017, SQL Server can also be set up in containers. I would love to hear about your recommendations and best practices in the comments! This list also exists for SQL Server 2014, SQL Server 2016 and SQL Server 2017. This is a checklist I’ve worked out for installing SQL Server 2019.