• The db server has 48gb RAM. We will be adding more RAM as the workload will be increasing within the next year.

    Regarding Dynamics, any experience with their SQL Performance Tool? i'm so hoping it will provide some insight to where our problems are. any advice about that app in general is appreciated. It's a beast!

    This was posted to my blog (not sure if it was you), "If you use maintenance plans, switch to Ola's index maintenance script(http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html). Indexes that fragment fast you can decrease the fill factor bit by bit." Just wanted to know what to expect. Of course i'll run it in dev first after I read and read!

    Thank you! I will stop switching to simple and will do log backups before and after switching to bulk.

    I really appreciate all the feedback! You are awesome!