Database Reference
In-Depth Information
F
Two factors that may change the number of servers running SQL Server are:
Whether or not scaling out will be implemented
Whether fault tolerance will be implemented at the database level or
instance level
Scaling out is the process of distributing an SQL Server load across multiple servers; thus,
the decision to scale out will increase the number of servers required. Multiple scale-out
options are available, and this section will provide a brief overview. Scale-out options require
design changes that occur at the database level and are outside the scope of this guide. It
is expected that any decisions relative to scaling out should be made in conjunction with the
database administrator.
Note that a new server, by definition,
is a new instance.
There's more...
The detailed information on the installation and configuration process is discussed in
Chapter
5
,
Management
of
core
SQL
Server
2008
R2
technologies
recipes:
F
Designing
Data
Integration
Solution
for
Master
Data
Management
F
Designing
and
Deploying
framework
to
use
Master
Data
Services
F
Troubleshooting
SQL
Server
Master
Data
Services
Designing applications to use federated
servers
The high level of performance is an immediate requirement in current application database
systems. In this scenario, to manage an application as 'high-available' and establish a load
balancing of processing load for each task across multiple servers is called Federated
Servers. Adding a federation of database servers to a highly-available system offers the
flexibility to manage the resources for mission-critical processes efficiently.
Getting ready
The application system that is always available (high-availability) is a key ingredient for the
success of every enterprise which establishes a federation of database servers, thereby
distributing the processing load across a group of servers by horizontally partitioning the data
in an SQL Server database. These servers are managed independently, but cooperate to
process requests on the database.
Search WWH ::
Custom Search