DBCC PAGE

  • Comments posted to this topic are about the item DBCC PAGE

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • Intersting question, Henrico, thanks
    had to read up on this (found it in Paul Randal's blog).

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

  • Stewart "Arturius" Campbell - Sunday, February 26, 2017 10:40 PM

    Intersting question, Henrico, thanks
    had to read up on this (found it in Paul Randal's blog).

    Indeed, his blog was the most documented resource I could come across on the topic.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • Thanks Henrico for an interesting question about undocumented DBCC commands.
    Clear explanation I found in this blog from Paul White. Interesting is also this Paul Randal's blog.😉

  • With the introduction of sys.dm_db_database_page_allocations in SQL Server 2012 we probably shouldn't be using DBCC IND any more - not because sys.dm_db_database_page_allocations is any less unofficial than DBCC IND (both are totally unofficial as far as I know) but because it (a) provides more information that DBCC IND and (b) gives us the information in the form of a nice system view which we can select from and join with other tables and so on without having to create a temporary table to hold the information.

    Tom

  • I went by Gail's opinion and as usual, she was right.

  • TomThomson - Monday, February 27, 2017 6:41 AM

    With the introduction of sys.dm_db_database_page_allocations in SQL Server 2012 we probably shouldn't be using DBCC IND any more - not because sys.dm_db_database_page_allocations is any less unofficial than DBCC IND (both are totally unofficial as far as I know) but because it (a) provides more information that DBCC IND and (b) gives us the information in the form of a nice system view which we can select from and join with other tables and so on without having to create a temporary table to hold the information.

    I wouldn't say that it is unofficial. DBCC IND was undocumented but is now on the deprecation list. For that reason and the nice easy friendly format that comes from the sys.dm_db_database_page_allocations function, I would recommend using the function instead (despite it also being undocumented).

    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

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

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