question

ezee avatar image
ezee asked

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
sql-server-2008dbcccheckdbsystem-tables
10 |1200

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

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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/
8 comments
10 |1200

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

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.
4 Likes 4 ·
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!
1 Like 1 ·
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.
0 Likes 0 ·
That's one thing that sucks about being UK based - we get to miss out on a lot of opportunities!
0 Likes 0 ·
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.
0 Likes 0 ·
Show more comments

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.