Post reply

Manage the suspect_pages Table on SQL Sever 2017

  • April 19, 2018 at 10:03 pm

    #344837

    Comments posted to this topic are about the item Manage the suspect_pages Table on SQL Sever 2017

  • April 19, 2018 at 10:04 pm

    #1987623

    Nice simple one to end the week on thanks Junior.

    ...

  • April 20, 2018 at 12:23 am

    #1987626

    Nice one to end the week on, Junior, thanks - learned something

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • April 20, 2018 at 5:17 am

    #1987637

    HappyGeek - Thursday, April 19, 2018 10:04 PM

    Nice simple one to end the week on thanks Junior.

    Thanks.

  • April 20, 2018 at 5:17 am

    #1987638

    HappyGeek - Thursday, April 19, 2018 10:04 PM

    Nice simple one to end the week on thanks Junior.

    Thanks.

  • April 20, 2018 at 12:36 pm

    #1987738

    Thanks for the instructive question.

    PS Does anyone know why the suspect_pages table is in MSDB and not in master? Just curious.

    -------------------
    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

  • April 20, 2018 at 4:18 pm

    #1987771

    webrunner - Friday, April 20, 2018 12:36 PM

    Thanks for the instructive question.

    PS Does anyone know why the suspect_pages table is in MSDB and not in master? Just curious.

    I'm guessing it's for access permissions issues.
    Because it is a table that can be accessed both for reading and also for writing by any user with permission in MSDB.

  • April 23, 2018 at 8:15 am

    #1987900

    Junior Galvão - MVP - Friday, April 20, 2018 4:18 PM

    webrunner - Friday, April 20, 2018 12:36 PM

    Thanks for the instructive question.

    PS Does anyone know why the suspect_pages table is in MSDB and not in master? Just curious.

    I'm guessing it's for access permissions issues.
    Because it is a table that can be accessed both for reading and also for writing by any user with permission in MSDB.

    Got it - thanks for your explanation!
    - 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

Viewing 8 posts - 1 through 7 (of 7 total)

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