Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

A. More DBA Manageability Best Practices

Appendix A. More DBA Manageability Best Practices

I would like to present this final recipe of the book 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.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint