Turns out if you plan on using Database Mail for your SQL Server, you’ll also need to 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.
0 kommentar(er)
