THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kalen Delaney

Geek City: SQL Server 2016 CTP3 In-Memory OLTP Internals Whitepaper

 

Just a quick note that my CTP3 paper has finally been published, and now I can start working on the final version!

Here’s the link:

http://download.microsoft.com/download/D/5/2/D52D374F-D442-4275-B570-0EB527102F4D/SQL_Server_In_Memory_OLTP_Internals_Overview_for_SQL_Server_2016_CTP3_EN_US.pdf

Enjoy!

~Kalen

Published Tuesday, January 19, 2016 7:23 PM by Kalen Delaney

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Chris Adkin said:

Are you in a position to disclose the exact tests supporting the claim that the in-memory OLTP engine is scalable up to four CPU sockets. Are you also in a position to disclose how either you or Microsoft worked around the pressure on key spinlocks as your tests neared the loading of all CPU cores across all CPU sockets.

By "Efficient scaling" do you mean that the transaction throughput curve was a straight line as the workload was scaled up ?.

January 21, 2016 4:02 AM
 

Yoshihiro Kawabata said:

Nice, and I want to read Real-Time Operational Analytics version, that in-memrory OLTP + non-clustered Columnstore index seems to resolve some "Unsuitable Application scenario".

January 22, 2016 9:40 PM
 

Russ Thomas said:

Good stuff, thanks again for your work Kalen!

January 26, 2016 10:52 PM
 

Kalen Delaney said:

Hi Chris

What if I just answered 'no'? :-)

I don't run the performance tests, Microsoft does, in their labs with many different customers. I am not involved with the testing so I just take the results they give me. Anything I can test for myself, as far as functionality, I will always verify before publishing, but for things that need a lab, or an application and data that will truly benefit from in-memory OLTP, I have to leave that to Microsoft.

~Kalen

February 26, 2016 8:16 PM
 

Chris Tucker said:

Not being a grammar Nazi, but trying to help. On page 73  you have an error in this sentence " Thjavascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("ctl00$_$ctl00$_$ctl00$ctl00$bcr$ctl00$_$form$_$btnSubmit", "", true, "", "", false, true))e bucket

could should be at least equal to the number of distinct values for the index key columns." You've used two verbs "could should".

Thank you

April 15, 2016 3:32 PM
 

Kalen Delaney said:

Thanks Chris! The 'could' should have been 'count' and it has already been corrected as I update the paper for RTM. Although it is now on page 84, not 73. :-)

The whole sentence is:  "The bucket count should be at least equal to the number of distinct values for the index key columns."

~Kalen

April 15, 2016 3:38 PM
 

Dr. Nick said:

Kalen,

Any estimates on the next edition of the MSSQL Internals book? It's 'bout time :)

April 30, 2016 7:34 PM
 

Kalen Delaney said:

Hi Dr. Nick

There will not be any more of the big SQL Server Internals books. The last one took over a year to write, and the publisher didn't get it published for over a year after that. And with a new version coming out every couple of years, I can't update the book fast enough to keep up with that. So I will be doing more smaller internals books, like my Concurrency and In-Memory OLTP books for Redgate.

Thanks

Kalen

May 24, 2016 12:47 PM
 

Kalen Delaney said:

Hi Dr. Nick

There will not be any more of the big SQL Server Internals books. The last one took over a year to write, and the publisher didn't get it published for over a year after that. And with a new version coming out every couple of years, I can't update the book fast enough to keep up with that. So I will be doing more smaller internals books, like my Concurrency and In-Memory OLTP books for Redgate.

Thanks

Kalen

May 24, 2016 12:48 PM
 

Dr. Nick said:

Sad to hear but understandable. I love reading your "deep dive" books... very useful. Looking forward to new printed material from you.

Thanks for replying!

June 4, 2016 8:07 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Favorite Non-technical Sites or Blogs

Privacy Statement