SQL Server Installation Best Practices Video
Wait! You only get one chance to do this right. Before you run setup.exe, there are some basic configuration steps that will make all the difference in performance and troubleshooting. Brent Ozar will explain his SQL Server Setup Checklist covering the page file, service accounts, memory settings, and hardware stress testing. We won’t cover scripted installations or slipstreaming — this half-hour session is for folks who click through the setup GUI because they only install a few servers per year.
https://www.youtube.com/watch?v=r7n1L5G1mZs
For the full details, check out our SQL Server Setup Checklist.
Related

Hi! I’m Brent Ozar.
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.
Get Free SQL Stuff
"*" indicates required fields

1 Comment. Leave new
Thanks Brent! This video has raised some important considerations our SQL DBA team will be including with our standard build documentation. I wasn’t aware of the hardware vendor tools that are available – great tip and great site.