Post reply

Detect Corrupt Statistics - Is there a way?

  • November 30, 2010 at 2:24 pm

    #1257046

    Hmm. Anything that causes stats corruption is a bug in SQL Server. Did they mean some SQL query is causing the corruption? Are they investigating the bug? This sounds very strange.

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

  • December 1, 2010 at 11:57 am

    #1257544

    Paul Randal (11/30/2010)

    Hmm. Anything that causes stats corruption is a bug in SQL Server. Did they mean some SQL query is causing the corruption? Are they investigating the bug? This sounds very strange.

    Nope,they just said this happened from an action from the application. From our side it is not possible to recreate this since we do not know which action made the stats corrupted.They did not pin point any specific query.

  • December 1, 2010 at 12:29 pm

    #1257561

    An application cannot cause corruption (of any form) unless it encounters a bug in SQL.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 1, 2010 at 8:36 pm

    #1257713

    Thanks Gail. I am really anxious to find the root cause, let me check with Microsoft. Thanks

  • December 1, 2010 at 8:43 pm

    #1257714

    Ask them to be specific. Maybe mention you're talking to me and I'll be discussing the case with Bob Ward. 🙂

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

  • December 2, 2010 at 2:03 am

    #1257747

    Paul Randal (12/1/2010)

    Maybe mention you're talking to me and I'll be discussing the case with Bob Ward. 🙂

    😀 You're evil sometimes....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 16 through 20 (of 20 total)

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