DBCC PAGE

Question

DBCC PAGE

Henrico Bekker

One Orange Chip

Points: 27652
More actions
February 26, 2017 at 5:13 pm

#341074

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

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

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

Stewart "Arturius" Campbell SSC Guru Points: 72498 More actions · Answer 1

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”

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 2

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

George Vobr SSCrazy Eights Points: 9916 More actions · Answer 3

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

TomThomson SSC Guru Points: 104773 More actions · Answer 4

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

Revenant SSC-Forever Points: 42467 More actions · Answer 5

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

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