Oct 20
SQL Server 2008 R2 Data Center Installation For SharePoint 2010

Here are what I consider the best practices and most realistic setup for SQL server when using the SharePoint 2010 Ent set of tools and features.

  • Server Specification Musts!
    • Try to follow the hardware and data volumes setups that I suggest here.  These are the configurations I found best after installing more than 200 of these same types of SharePoint systems.
  • Use Dedicated SQL Server and dedicated LUN
  • 16GB Memory - Disable pagefile.sys to save on local drive space
  • 4 CPU

    Make certain the L2 cache per CPU is greater than 2MB

  • You can theoretically scale out beyond 4 TB of data – beyond the 200 gig recommended threshold, however you should use DPM or SQL backups instead of other systems such as Backup Exec and Tivoli systems to do backup on these systems
  • SQL Setup
    • Use asynchronous mirroring of DB services - http://msdn.microsoft.com/en-us/library/ms187110.aspx
      • Only for more advance Large deployments
    • Data Stores - Dynamic Disks GPT disks - http://support.microsoft.com/kb/140365
      • C:\OS - 35GB
      • E:\SQL_Data_Volume – 600GB (64K Allocation unit size)
      • F:\tempdb – 100GB (64K Allocation unit size)
        • Configure the Temp DB to be at least 10% of total content DB size or the size of the largest table
      • G:\SQL_Backup – 300GB (64K Allocation unit size)
      • H:\SQL_Log_Volume – 100GB (64K Allocation unit size)
  • Prerequisites
    • Install .NET Framework
      • Server Manager > Features > Add Features > .NET Framework...

SQL SERVER 2008 INSTALL

  • Installation
    • New installation or add features to an existing installation
  • Setup Support Files
    • Click Install
  • Setup Role
    • SQL Server PowerPivot for SharePoint
      • New Server

  • Feature Selection

  • Installation Rules
    • Verify Status for all Rules Passed
  • Instance Configuration
    • Use a Named Instance unless the Default instance is absolutely required
      • Named Instance
        • SHAREPOINT
      • Instance Root Directory
        • E:\

  • Disk Space Requirements
    • Verify available space
  • Server Configuration
    • Request the following Service Accounts creation in Active Directory and use these to run your services
      • Sqlserv - SQL Server Agent (needs to be an admin account on the server)
      • Sqldb - SQL Server Database Engine
      • Sqlas -SQL Server Analysis Services
      • Sqlrs - SQL Server Reporting Services
      • Sqlis - SQL Server Integration Services
        • These are the adjusted account settings
          • Check the Event Logs to make certain the various accounts are not failing

       

  • Database Engine Configuration
    • Windows Authentication Mode
    • Add AD Admin Group
      • Current User
      • SERVERS ADMIN Group
      • spfarm
    • Data Directories (separate these out for recovery and performance reasons)
      • Data Root Directory
        • E:\
      • User database directory
        • E:\
      • User database log directory
        • H:\
      • Temp DB directory
        • F:\
      • Temp DB log directory
        • F:\
      • SQL Backup
        • G:\
    • FILESTREAM
      • Enable- BLOB Functionality

  • Analysis Services Configuration (OLAP)
    • Add AD Admin Group
      • Current User
      • SERVERS ADMIN Group
      • spfarm
    • Data Directories
      • Data Directory
        • E:\
      • Log File Directory
        • H:\
      • Temp Directory
        • F:\
      • Backup Directory
        • G:\

  • Reporting Services Configuration
    • Install the SharePoint integrated mode default configuration

  • Error Reporting
    • Do not check the Send Error Reports option
  • Installation Configuration Rules
    • Verify Status for all Rules Passed
  • Ready to Install
  • Installation Progress


POST INSTALLATION PROCESSES

  • Check for Product Updates
  • Instance Alias Configuration
    • Create alias for DB servers
      • In SQL Server Configuration Tools > SQL Server Configuration Manager, expand SQL Native Client Configuration, right-click Aliases, and then click New Alias.
        • See the section on SQL Server 2008 R2 Install > SQL Alias's and SharePoint
  • DB Sizing
    • Size the databases ahead of time
      • Content 60mb
      • Config 10mb
    • The max upload size of the web app should match the auto grow size for the DB
      • DB properties>File>
        • Ideally you should size the DB and not allow auto growth
          • This will reduce and prevent fragmentation of the DB and keep the disk contiguous.   

Comments

There are no comments for this post.

 ‭(Hidden)‬ Blog Tools