Post reply

Suspect Pages

  • February 9, 2016 at 9:21 pm

    #75733

    Comments posted to this topic are about the item Suspect Pages

  • February 9, 2016 at 10:33 pm

    This was removed by the editor as SPAM

  • February 10, 2016 at 12:15 am

    #1857605

    learnt something new today. thanks for the question steve.

  • February 10, 2016 at 5:28 am

    #1857666

    Great question, Steve, thanks. This is an area I've been interested in for some time and I'm just starting to really dig into it.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • February 10, 2016 at 9:29 am

    #1857768

    Steve Jones - SSC Editor (2/9/2016)

    Comments posted to this topic are about the item <A HREF="/questions/Administration/137322/">Suspect Pages</A>

    Great question, thanks!

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • February 10, 2016 at 10:26 am

    #1857793

    For years I've read that table as part of my nightly maintenance.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • February 10, 2016 at 3:57 pm

    #1857889

    Wayne West (2/10/2016)

    For years I've read that table as part of my nightly maintenance.

    That is good advice. I think far too many people ignore that table.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • February 10, 2016 at 4:17 pm

    #1857891

    SQLRNNR (2/10/2016)

    Wayne West (2/10/2016)

    For years I've read that table as part of my nightly maintenance.

    That is good advice. I think far too many people ignore that table.

    It's very rare that I've seen anything there, kinda like DBCCs rarely find errors as the quality of SQL Server has improved over the years, but you only have to be burned once to appreciate DBCCs and suspect page detection.

    Always a good idea to fix things at the first hint of trouble than to wait until the whole system explodes.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • February 11, 2016 at 12:57 am

    #1857928

    Thanks for the question.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 8, 2016 at 4:51 pm

    #1863865

    Thank you for the question.

Viewing 10 posts - 1 through 9 (of 9 total)

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