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)