Internals Changes

Question

Post reply

Internals Changes

Grant Fritchey

SSC Guru

Points: 398233
More actions
January 11, 2008 at 9:09 am

#178097

Has anyone seen any blog entries or white papers documenting any fundamental change to the way 2008 processes queries?
I mean, is it still split into the relational engine and the storage engine? Does the relational engine still use the parser then the algebrizer then the optimizer?
I know there have been optimizations to deal with spatial data types among other things, but I was wondering if the core process was still basicall the same.
----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 1

You could try Paul Randal's blog: http://www.sqlskills.com/blogs/paul/ Might well be something there.

The impression I've got is that 2008 is a very small change, compared to 6.5-7 or 2000-2005

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Grant Fritchey SSC Guru Points: 398233 More actions · Answer 2

Thanks. His blog seems to be offline right now. I'll check on it later.

I understood that there were few if any fundamental changes, but I just wanted the chance to confirm. Thanks again.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software

Steve Jones - SSC Editor SSC Guru Points: 730740 More actions · Answer 3

I haven't seen much in my list of blogs (50-60) that I check. There are some good entries with Craig Freedman, but seems to be 2005.

I don't think there are a lot of 2008 changes in this area. It seems like more they've bolted on more things, like DMF, processor limits, etc.

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

Grant Fritchey SSC Guru Points: 398233 More actions · Answer 4

Excellent. Thanks Steve.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software

Paul Randal One Orange Chip Points: 29544 More actions · Answer 5

There are no changes in this area in SS2008.

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005