Large Scale Deployment Using SQL FineBuild

Previous SQL Server Always On Install	Large Scale Deployment Overview Next

This section describes how deployments of standardised builds of SQL Server to a large number of machines can be done and suggests an architecture that can be used.

The information given in the sections below is suitable for someone with limited skills in deploying SQL Server, but the information is also of use to experienced staff.

Item	Comment
	Deployment Planning
Large Scale Deployment Overview	Overview of items needed for Large Scale deployment
Development, Test and Production Environments	Dedicated environments for each stage of deployment
SQL Server Version and Edition	Exploiting the best features of SQL Server
Connection String Stability	Maintaining Connection String stability across changes to the SQL Server topography
Scale Up and Scale Out	Choosing Correct Architecture for Line of Business and Business Continuity
SSAS and PowerBI Optimisation	Optimising SSAS and PowerBI CPU and Memory Use
Site SQL Files Folder
	Role Files
Site Level Default Values	Parameter values that should be applied to all SQL FineBuild installs
Workhorse Server Role	Standard server role for deployment on high-end hardware
Lightweight Server Role	Standard server role for deployment on low-end hardware
Legacy Server Build	Special server build for old version of SQL Server
Management Server Role	The Master host role for Master/Target components
Developer Workstation Role	Workstation role for deployment on desktop hardware
Administration Server Role	Client role, for DBA Administration purposes
	Other Deployment Items
Installing SQL Server on Windows Core	Limitations when installing SQL Server on Windows Server Core
Install SQL Server Using Altiris	Using SQL FineBuild with a deployment tool

Copyright FineBuild Team © 2014 - 2021. License and Acknowledgements

Previous SQL Server Always On Install	Top	Large Scale Deployment Overview Next