LLI Wiki — My Digital Knowledge Base

Prerequisites checklist for SQL Server Always On servers

Checklist of points to settle (AD, network, accounts, storage, instance) before building SQL Server 2022 servers for an availability group.

Before building a pair of virtualised SQL Server 2022 servers for an Always On availability group, it helps to agree on a checklist with the infrastructure, Active Directory and storage teams. This article lists the points to settle, as a generic template.

General

Item Value / decision
Operating system Windows Server 2022 Standard
SQL Server version SQL Server 2022 Standard
Location Same site, nodes on different hypervisor hosts
Databases Estimate number, size and activity (example: 4 per server)

Active Directory

Network

Accounts

List the accounts to request before installation:

Server sizing (example)

Item Example
CPU 8
RAM 48 GB
Virtual SCSI adapters 2 (spread the storage across them)
Virtual network adapters 1

Other points: identical volumes and folder structure on all replicas, required Windows hotfixes installed, and DTC configured if needed.

Storage

Use separate volumes (GPT) per instance and per file type, with a 64 KB allocation unit size for data, log and system volumes:

Volume Allocation Example size
System OS (C:) GPT 100 GB
Data GPT, 64 KB 700 GB
System databases GPT, 64 KB 40 GB
tempdb GPT 40 GB
Log GPT, 64 KB 60 GB

When two instances share a server, repeat the same layout on a second drive letter.

Backup

Decide on a third-party backup tool (Veeam, Avamar, ...) and/or native backups to a local drive.

Instance

SSAS server (separate VM, tabular mode)

Item Example
Type Tabular mode
Note Install the local database engine only for SSIS
CPU / RAM 4 / 16 GB
Disks C: 80 GB, D: 80 GB
Mastodon LLIMastodon SocialFosstodon