Tech Paper - Installation Checklist

Version 2

    Deploying the ArcFM Solution on SQL Server White Paper

     

    Use the following checklist to assure a successful installation:

     

    Windows Server Version

    • 64-bit edition of Windows Server® 2008 R2 Enterprise

     

    SQL Server Version

    • Microsoft® SQL Server® 2008 Enterprise Service Pack 2 (SP2), or Microsoft® SQL Server® 2008 R2 Enterprise, or Microsoft® SQL Server® 2008 R2 Datacenter

     

    ArcFM Solution

     

    Configuration Settings

    • Windows Hotfix KB976700
    • Lock pages in memory privilege granted to SQL service account

     

    SQL Server Configuration

    • Trace flag 1118 added to SQL Server startup parameters
    • Database log and data files are properly sized
    • AUTO_CREATE_STATISTICS and AUTO_UPDATE_STATISTICS options for the database are turned on (default setting)
    • SQL Server maintenance jobs created and active

     

    Indexes on Standard Fields Created (post-installation script)