June 30, 2015 at 10:21 am
Hi All,
Not sure if this is the place to put this but I was wondering if anyone knows of a good white paper that goes over how SQL handles queries. What I mean by this is, a white paper that goes over how the optimizer works, the order SQL runs transactions, how it chooses plans, etc. I want a very detailed white paper if there's one out there.
Thanks,
Josh
June 30, 2015 at 10:49 am
Kevin Kline does a good 200 level talk on SQL Server architecture, starting with how the database engine receives SQL queries and then parses, compiles, caches / re-uses, executes, retreives data pages, returns resultset, etc. end to end. Below is a YouTube video from PASS and also one of his slide decks.
https://www.youtube.com/watch?v=34VqSliEfsc
http://kevinekline.com/slides/sql-server-internals-architecture/
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 30, 2015 at 11:00 am
Not a whitepaper, but: http://www.amazon.com/Microsoft-Server-Internals-Developer-Reference/dp/0735658560/ref=sr_1_1?s=books&ie=UTF8&qid=1435683605&sr=1-1&keywords=sql+server+internals
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
June 30, 2015 at 11:19 am
Perfect, thanks all.
July 1, 2015 at 7:55 am
A second vote for the Internals book. It's great. My book on execution plans does go over how the optimizer works, but not in as much detail. Plus, you can download it for free from Redgate.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply