• Eric M Russell (5/2/2013)


    There is a database option called AUTO_UPDATE_STATISTICS_ASYNC that may help in your situation.

    http://weblogs.sqlteam.com/tarad/archive/2008/06/16/Asynchronous-Update-Statistics.aspx

    Alternatively, consider turning off Auto Update of Statistics database option, and then schedule a job or maintenance plan to manually update statistics during non-peak hours.

    Thanks Eric, I have been looking into AUTO_UPDATE_STATISTICS_ASYNC.

    I'm a little hesitant, because it requires a CU to avoid a memory leak, but I think it's my best option at this point:

    http://support.microsoft.com/kb/2778088