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.
For the full details, check out our SQL Server Setup Checklist.
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.