Post reply

Missing Statistics

  • September 17, 2003 at 8:57 pm

    #81114

    Hi all

    Im getting mightly annoyed with profiler of late, this product really needs a revamp to be half useful at times. Anyhow 🙂

    Running some traces on prod, checking for "Missing Column Statistics". Im a little confused here, I am getting frequent messages realted to a take that is hit regularily (primarily reads), with this:

    NO STATS:([training_product]., [training_product]., [training_product]., [training_product]., [training_product]., [training_product].)

    ok fine. I have auto-update stats on, I update stats manually (via dts custom joppy) each night, and still get this. I jump on the job and iss update statistics with all and a few minutes later these messages pop up...

    Thoughts?

    Cheers

    Ck

    Chris Kempster

    http://www.chriskempster.com

    Author of "SQL Server 2k for the Oracle DBA"


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"

  • September 17, 2003 at 10:47 pm

    #474800

    If practical, run an update statistics with fullscan. Maybe the stats is not accurate enough.

    What is the number of rows in the table and value for the column rowmodctr in table sysindexes(indid=1). The value for the column rowmodctr after the update statistics should be about 0

    Lastly, maybe run a sp_recompile.

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

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