few qq on SQL 2005 DBCC data PAGE output

• Ramukar LivingForSQLServer

  SSCommitted

  Points: 1749

  More actions

  March 3, 2010 at 7:27 am

  #156742

  Hi, can anyone please explain use of BUFFER section in DBCC PAGE output like bpage, bhash, breference etc. I really couldnt find useful link reg. this section (sql 2005).

  and in PAGE HEADER section i could see both GAM & SGAM status as ALLOCATED (test table have only one record). is this valid scenerio?

  and in SQL 2005 DBCC PAGE Slots section, i could see a word 'Memory Dump'. if im correct i havent seen this word in SQL 2000 DBCC PAGE output.

  here PAGE refers any SQL 2005 DATA page.

  it would be great if anyone could put some light on this.

  abt me: im a DBA givig some basic level sql query performance tuning solution to my team. intrested in & learning SQL Server architecture & Performance tuning part.

  thanks in advance.

• Locker916

  SSC Journeyman

  Points: 97

  More actions

  March 3, 2010 at 10:04 am

  #1127909

  I looked around a bit and found this article about using DBCC Page. You may have already read it but just in case: