PreRequisites

08 Feb 2022 18838 views 0 minutes to read Contributors

Hardware 

Hardware

Component

Description

Setup as

Checked / Present

RAID

RAID

Fault-tolerance

RAID1(0) for DATA/TEMPDB/LOG/INDEX files

RAID1/5 for BACKUP files

CACHE

BBWC

enabled

Write cache

enabled

Read /write cache ratio

60/40 (depends on your workload)

DISKS

SAS

Operating System

10K - RAID1 minimum - 64K Preformatted 100%

15K – RAID1 recommended - 64K Preformatted 100%

Backup disk

10K - RAID1/5 to hold backup’s - 64K Preformatted 100%

SSD

SQL Server Data Files

RAID1 – 64K Preformatted 100%

MEMORY

SIZE

 

16GB minimum

32 GB recommended or greater depending on requirements

ILO/iDRAC

 

Support

 

Software

OS

Component

description

Setup as

Checked / Present

OS

Version

Windows

Windows Server Standard / Enterprise

SP

Service Pack

Latest

Volumes

OS

OS

C:\ 

PageFile

Page File

X:\

SQL Server

TempDB

N:\  (64K, Full Formatted)

Logfiles (LDF)

T:\LOGS  (64K, Full Formatted)

Database files (MDF)

I:\DATA   (64K, Full Formatted)

Backup

Backup Files

Z:\ (any size on SAS enough to hold backup’s for business retention) or any network share

Mounts

ISO

ISO Mounting tool

Any tool to mount ISO’s

Security

OS

Component

description

Setup as

Checked / Present

Security

Windows firewall

 

Off

Antivirus

 

Off. If On exclude all SQL Server disks

Domain

AD

Component

Description

Setup as

Checked / Present

Service account

SQL Server Agent Service

User account to run SQL Agent service

DOMAIN\sqlagent

Assign the local computer right: "Perform Volume Maintenance Tasks"

SQL Server Service

User account to run SQL service

DOMAIN\sqlservice

Assign the local computer right: "Perform Volume Maintenance Tasks"

Domain Groups

SQL Server DBA’s

AD Global group to host DBA Administrators

DOMAIN\GROUP

Service accounts should be member of this group

SQL Server Users

AD Global group to host DBA users

DOMAIN\GROUP

DNS

DNS Aliasses

 

Create DNS aliasses to connect to SQL Server

SQL Server

SINGLE INSTANCE  

(no high availability) 

Component 

Description 

Setup as 

Checked / Present 

SQL Server 

Version 

Version 

SQL Server Standard 

 

Instance name 

SQL Server instance 

DEFAULT 

 

Binaries 

 

ISO mount 

 

Listening ports 

Listening ports 

1433 – 1434 

 

 

MULTIPLE  INSTANCES

(HIGH AVAILABLE)

Component

Description

Setup as

Checked / Present

SQL Server

Version

Version

SQL Server Enterprise Edition

Instance name

SQL Server instance

DEFAULT

Binaries

 

ISO mount

Listening ports

Listening ports

60000 recommended

Always ON

Availability Groups

VIP and VDNS

Add extra IP and DNS to decorate AG group listener

Windows Clustering Services

Windows Clustering

Installed

Download prerequisites

Report a Bug

In this article