Archive for June, 2013

Hekaton resources

Now that SQL Server 2014 CTP1 is available many of us will be playing with the Hekaton functionality. To understand what is going on under the covers here is a very good internals presentation given by Sunil Agarwal at the recent TechEd North America 2013:

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/DBI-B308#fbid=stWIq0gzfSk

In this link Sunil explains filestream data files (each 128Mb in size), delta files, merging of delta files, offline checkpoint process, minimal transaction log writes, new fn_dblog_xtp function plus much, much more.

Sunil presented two other Hekaton sessions at the same conference:

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/DBI-B204#fbid=stWIq0gzfSk

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/DBI-B307#fbid=stWIq0gzfSk

Enjoy.

Leave a comment