SQL Server Performance

Database Setting

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by travistan, May 24, 2008.

  1. travistan New Member

    Hi ,
    I having a DB (Sql 2005) which having 32 GB RAM and 16 CPU. This DB server purely is for ETL and Reporting purposes. It is a ROLAP DB.
    1. It is good to turn on the AWE and set to 28 GB RAM and reserve 4GB for OS process ?
    2. Anything else need to be set in order to boost up the ETL loading and performance (Beside Index) in the Sql Server itself ?
    Thanks ,
    Travis
  2. satya Moderator

    Do you see any performance issues lately with current settings?

Share This Page