Sql Server Internals…

These days I am learning lots of sql servr internals. I am reading blogs by Paul Randal – www.Sqlskills.com and gone thorugh his MCM trainings. For me Paul is the mentor of sql server, I learn most of the internal/basics of sql server from him(virtually).

Thanks you Paul from the bottom of my heart. Paul is sharing lots of good information about sql server (which generally not much expert does 🙂 )

Will try to write some good blogs about those soon, which includes

Page

Extent

 Different internal allocation pages

  • page 0:  File header
  • Page 1:  PFS
  • Page 2:  GAM
  • Page 3:  SGAM
  • Page 6:  DIFF
  • Page 7:  ML
  • Page 9:  Boot page

Allocation Unit

IAM

Advertisements
This entry was posted in Internal and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s