Database Reference
In-Depth Information
More DBA
Manageability Best
Practices
I would like to present this inal recipe of the topic more like a list of best practices that I have
collected and implemented during my DBA working years. I would like to stress that few may
look elementary, but they is logical, which are overlooked most of the time. The following is
the list of DBA manageability practices that are important to handle day-to-day tasks of the
SQL Server 2008 R2 environment.
1.
Design process: Determine the Project Scope and which roles will be required.
2.
Design the SQL Server Database Engine infrastructure, Integration Services
infrastructure, and wherever necessary SQL Server Analysis Services and SQL Server
Reporting Services infrastructure.
3.
Storage: Always perform a capacity planning exercise by compiling the amount of
database storage that is needed for the next one or two years.
Required Information
Description
# Users Per Server
Total number of users hosted by that server.
% Concurrent Users
The percentage of users connected to the server during peak
times.
Storage Capacity in Gigabytes
The calculated disk storage capacity needed.
% Buffer Factor (for growth)
The percentage of disk storage growth allowed by the system.
Read % of IOPS
The percentage of IOPS that are Read operations.
Write % of IOPS
The percentage of IOPS that are Write operations.
Disk Size (GB)
The drive size being considered for the storage system.
Search WWH ::
Custom Search