question

Therealist avatar image
Therealist asked

What are theTypes of pages in sql server?

Data pages,index pages, GAM,SGAM apart from these are there any type of pages to list out and how could i find out the information that is within the pages in sql server, any command to look into it and what is GAM and SGAM ,of course page contains data but is it possible to see what kind of info in it exactly?
page
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
DenisT avatar image
DenisT answered
Look at my answer here -- https://ask.sqlservercentral.com/questions/115217/pages-in-sql-server.html -- Paul Randal is the guy whose blog you need to read. You'll find all the answers you just asked! Look for DBCC PAGE.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.