Post reply

Database Maintenance job failing contineously?

  • November 5, 2011 at 9:00 am

    #259552

    Hi Friends,

    One of my production server on weekly Database Maintainence job is running. That contains (updatestats, reindex,full scan and degug jobs. This job is failing last 6 months, due to script. I corrected that script, but now i would like to know if i run this job on my server after 6 months.

    Will it create any problem on my database? Because of Updatestats.

    Please i need your valuable suggestions in this regard.

    Thanks In Advanace.

    ________________________________________
    M.I.
    [font="Times New Roman"]

    Learning is a path with no destination...
    [/font]

  • November 5, 2011 at 9:22 am

    #1403629

    Hoping that you have done the right corrections to your script, it shouldn't cause any harm to your database.

    M&M

  • November 5, 2011 at 12:01 pm

    #1403651

    I think that if the script is good it will "solve"problems instead of "creating" them. 🙂

    Good luck and let us know how did it go.



    My blog

  • November 7, 2011 at 5:41 am

    #1403861

    Without more detail, it's hard to know for certain. For example, updating stats is good, but rebuilding an index also updates the stats, and with a full scan, not sampled. So, if you update stats after an index rebuild, you can actually hurt the stats.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • November 8, 2011 at 8:55 am

    #1404630

    MSQLDBA (11/5/2011)

    Hi Friends,

    One of my production server on weekly Database Maintainence job is running. That contains (updatestats, reindex,full scan and degug jobs. This job is failing last 6 months, due to script. I corrected that script, but now i would like to know if i run this job on my server after 6 months.

    Will it create any problem on my database? Because of Updatestats.

    Please i need your valuable suggestions in this regard.

    Thanks In Advanace.

    1) you clearly need to monitor your servers better.

    2) We cannot answer your question - WAY too many variables

    3) do not use maintenance plans - they have lots of unfortunate issues. use the awesome free and documented scripts from ola.hallengren.com

    4) given stuff from above I HIGHLY recommend you get a consultant on board to give your systems a review and address all the issues you likely have.

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

Viewing 5 posts - 1 through 4 (of 4 total)

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