Database Reference
In-Depth Information
Figure 2.6 SQL Server database-provisioning process example with timeframes.
Now, the flowchart with timeframes added might look slightly different in your
organization; however, it should give you a general idea concerning the time it takes to
deploy a database into an infrastructure. If we were to move up a level in this
discussion, we could ask how this affects our business's ability to generate revenue. If it
takes a month just to provision the database for a project, how are we helping time-to-
market for new corporate initiatives?
What if we could automate our workflow, through abstraction and predefined policies,
to reduce this process to half the amount of time, or even a quarter of the amount of time,
so that we can quickly respond to the business's needs?
As a DBA, you now can create the “golden template.” That template can be a
combination of different interrelated VMs. For example, if one VM contains the
application layer and another VM contains the database layer, the two VMs are tightly
interconnected. You could create a single template that contains both and also include
all the security rules associated with them. You can very quickly create consistent and
complete copies of this complex production database environment, thus taking this
process from weeks to hours.
Database Tiering
 
 
Search WWH ::




Custom Search