Installation Prerequisites

29 Sep 2019 0 minutes to read Contributors

Hardware

Hardware

Component

Description

Setup as

Checked / Present

RAID

RAID

Offer fault-tolerance

RAID1(0)

CACHE

BBWC

enabled

Write cache

enabled

Read /write cache ratio

60/40

DISKS

SAS

Operating System

10K 72GB - RAID1 minimum

15K 146GB – RAID1 recommended

Backup disk

10K - Any size – RAID1 to hold backup’s

SSD

SQL Server Data Files

300GB - RAID1 – 64K Preformatted 100%

MEMORY

SIZE

Memory size

8GB minimum

32 GB recommended

ILO Console

Open ILO console

Enabled

ILO 

Teaming

NIC interface bundle

Enabled / failover / load balanced

Software

OS

Component

description

Setup as

Checked / Present

OS

Version

Windows

Windows Server 2012 Standard

SP

Service Pack

Latest

Volumes

OS

OS

C:\ (72GB on SAS)

PageFile

Page File

X:\ (1 1\2 RAM) on SSD

SQL Server

TempDB

N:\ (146 GB on SSD)

 (64K, Full Formatted)

Database Logfiles (LDF)

T:\ (146 GB on SSD)

 (64K, Full Formatted)

Database files (MDF)

I:\ (300GB on SSD)

 (64K, Full Formatted)

Backup

Backup Files

Z:\ (any size on SAS enough to hold backup’s for 2 week retention)

Security

Firewall

 

Off

Antivirus

 

Off. If On exclude all SQL Server disks

Mounts

ISO

ISO Mounting tool

Any tool to mount ISO’s

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

Name resolution

Hosts file

DNS resolution

DBA group able to access local host file

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

 

In this article