SQL Server Deployment Architecture

Previous Large Scale Deployment Using SQL FineBuild	Development, Test and Production Environments Next

One of the strengths of SQL FineBuild is the ability to deploy standardised builds of SQL Server to a large number of machines. This section describes how these deployments can be done and suggests an architecture that can be used.

The items in this section of Large Scale Deployment Using SQL FineBuild will focus on the components of an architecture that can be used for the deployment of servers. The Large Scale Deployment Overview will focus on building the deployment process.

The following terms are used throughout the discussion on Large Scale Deployment:

Item	Description
Scale Up	Increasing the Core Count and Memory for a given instance of SQL Server
Scale Out	Distributing the SQL Server workload over a number of Windows instances
Line of Business (LoB) workload	The resources an organisation needs to process its day to day business
Business Continuity Operations (BCO)	Provision of LoB capability at an alternative location when the primary data centre is not useable
SQL Server Licencing	The Microsoft Licensing requirements for implementing the chosen environment
Recovery Point Objective (RPO)	A measurement of time between a disruption event and the most recently available LoB data available at an alternative data centre. This time difference is the amount of data loss that a business is willing to tolerate
Recovery Time Objective (RTO)	The measurement of time between a disruption event and being able to continue LoB operations at an alternative data centre
Service Level Agreement (SLA)	The 'contract' between the Technical Team and the Business Users on what level of service should be provided in various circumstances
Service Tiers	The relative importance to the Business of a given database and application. Best Practice recommends that applications are grouped into Tiers (eg Gold, Silver, Bronze) with each tier having specific SLA objectives for performance, RPO and RTO

Copyright FineBuild Team © 2021. License and Acknowledgements

Previous Large Scale Deployment Using SQL FineBuild	Top	Development, Test and Production Environments Next