2 Replies Latest reply on Apr 16, 2010 10:56 AM by Silvercoupe

    New LD9 install - Database questions

    Silvercoupe Apprentice



      We have LD9 up and running in our environment and now I'm going back to make sure SQL is running as well as possible.  I need to set up a Maintenance Plan and make sure memory is allocated properly on the DB server.  Most of the Docs I could find reference settings for SQL 2005 and Server 2003.  Both our core and DB are Server 2008 R2 64-bit.  SQL is 2008 Standard Edition.


      1.  Should AWE memory allocation be enabled on our SQL 2008 server, or is it OK being a 2008 R2 64-bit box?


      2.  Is a typical maintenance plan with nightly re-indexing appropriate or is there a doc somewhere with better recommendations?