Post reply

Update Statistics Maintenance Plan

  • June 4, 2013 at 12:59 am

    #278137

    Hi All

    I am using SQL 2012 SP1

    I have set up an update statistics maintenance plan to update the stats on all tables in my database - The job seems to be stuck at the beginning phase of the maintenance, this is where it queries the tables - It's been there for 10 hours and hasn't even got to the part where it actually updates any stats.

    I'm not seeing any waits

    Has anyone else seen this before?

    Thanks

  • June 4, 2013 at 7:23 am

    #1620964

    I didn't even reads your post honestly. All I saw was the title. Never, EVER use maintenance plans in SQL Server for ANYTHING that is covered by the FREE, AWESOME, DOCUMENTED stuff you can find at Ola.Hallengren.com!!! 😎

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • June 4, 2013 at 7:25 am

    #1620965

    TheSQLGuru (6/4/2013)

    I didn't even reads your post honestly. All I saw was the title. Never, EVER use maintenance plans in SQL Server for ANYTHING that is covered by the FREE, AWESOME, DOCUMENTED stuff you can find at Ola.Hallengren.com!!! 😎

    I'm heading down that route.

    For now, I've set up a basic cursor that just loops through all of the tables and updates the stats. All good so far...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply