Critical System Tables in 2008

Can anyone tell me what the critical system tables are in 2008 that are checked within a CHECKDB? I'm trying to break down CHECKDB into parts as described on [msdn][1] as the full check takes too long

In 2005 they are

  • sysallocunits
  • syshobts
  • syshobtcolumns
  • sysrowsets
  • sysrowsetcolumns
[1]: http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/19/636410.aspx
more ▼

asked Jul 13, 2010 at 09:27 AM in Default

ezee gravatar image

34 3 3 5

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I honestly don't know, but I would suggest you [go here][1] to get the answers. Paul wrote the original DBCC process and is still extremely involved with SQL Server development.

[1]: http://www.sqlskills.com/blogs/paul/
more ▼

answered Jul 13, 2010 at 11:10 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

I like and loathe reading Paul's blog. I like it because I learn so much, and it's so well written, and I loathe it because it usually reminds me how rubbish I am. I would love to meet him one day / take a course with him.
Jul 13, 2010 at 11:24 AM Matt Whitfield ♦♦
I have met him. Actually I was on stage with him and his wife at the last PASS summit for a game. It was an horrifyingly embarassing beating because they were so very smart and well informed and I'm just not. But, they're great people, very nice. Excellent teachers and presenters too.
Jul 13, 2010 at 12:13 PM Grant Fritchey ♦♦
That's one thing that sucks about being UK based - we get to miss out on a lot of opportunities!
Jul 13, 2010 at 12:16 PM Matt Whitfield ♦♦
I've only been to one of Paul's classes, but I've attended a ton of Kim's. She's scary smart. I learn something every time. I thought they traveled over there occasionally... Wait, they were just in Ireland for a couple of weeks at least. I know it's another country, but it's only a few hours away.
Jul 13, 2010 at 12:19 PM Grant Fritchey ♦♦

To to add to @Grant post... I think this article is the best http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Complete-description-of-all-CHECKDB-stages.aspx

They we're doing in a master class @ heathrow a couple of weeks ago.. Impressive!
Jul 13, 2010 at 12:56 PM sp_lock
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 13, 2010 at 09:27 AM

Seen: 1318 times

Last Updated: Jul 13, 2010 at 11:58 AM