Home Forums SQL Server 2012 SQL 2012 - General SQL Server 2012, update Stats and Index Organize taking 16 hours for execution‌‌ RE: SQL Server 2012, update Stats and Index Organize taking 16 hours for execution??

  • February 20, 2018 at 3:20 am

    #1980406

    santosh.mane - Monday, February 19, 2018 11:34 PM

    Hi,

    We have SQL Server 2012, On production database SQL job update Stats and Index Organize taking 16 hours for execution. Size of the database is around 300 GB.
    Please advise urgently how to resolve this issue.

    Thanks & Regards,
    Santosh

    How is the job doing the update?  If it's using a Maintenance Plan, stop using that immediately, and get Ola Hallengren's solution or something similar in order to do targeted maintenance.

    John