Home Forums SQL Server 2008 SQL Server 2008 - General UPDATE STATISTICS with FULLSCAN -- implications? RE: UPDATE STATISTICS with FULLSCAN -- implications?

  • February 23, 2017 at 7:36 am

    #1929950

    Grant Fritchey - Thursday, February 23, 2017 6:57 AM

    bmg002 - Wednesday, February 22, 2017 3:12 PM

    What version of redgate SQL Monitor are you on?  Is it 7.0.0 or 7.0.1?  If so, you may want to upgrade to 7.0.2.  Redgate SQL Monitor 7.0.0 has a bug in it that killed performance on our SQL databases to the point where queries that should take less than a second were taking hours to complete and it required a restart of the SQL Instance to fix.
    If it is version 6 or lower, then this likely isn't your issue or if it is version 7.0.2 then you shoudl be fine as well.

    Sorry you had issues. Let me know if I can help out.

    Oh I love the tool and all of redgate tools.  Plus, since we upgarded to 7.0.2 it has been working great with the exception of reports being slow.  I have a report that is scheduled to go out at midnight and I'll get it anywhere from 12:02 AM to 9:30 AM.  It is a bit of a surprise.
    But support is very quick in helping me with it and even with the issues I hit, I'd still recommend the tool to anybody I know.
    I have a support ticket open for DLM Dashboard right now as it is being grumpy on our system but now I feel I'm getting off topic.

    But back on topic - did updating statistics help?

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.