How Microsoft SQL Server Went Multi-Platform: SQLPAL

How did Microsoft made SQL Server available on Linux, Containers and ARM CPUs?

We'd love to tell the story on how we made SQL Server available to ecosystems outside of Windows in this talk. It's a great story that involves quite a bit of interesting technologies and we'd like to share that with everyone!

Speakers:
Argenis Fernandez
Brian Gianforcaro
Eugene Birukov

Video: https://youtu.be/zq1WTLnntIg

Transcript

1. @dbargenis bgianf
2. Using SQLPAL, the SQL Server database engine went from… Only on Virtual Machines
3. On both virtual machines and containers To Being Available Across ALL Of These
5. SQL Server on Linux and Containers: A Story in 4 Numbers 5 3 24 25 Estimated number of years to port SQL Server to Linux natively Weeks to working prototype using SQLPAL Months to release, including support for containers Million Docker container pulls
6. Ring 3 SQL Server SVCHOST NTDLL.DLL NTDLL.DLL KB.DLL KB.DLL SQLPAL.DLL (PE) win32k.sys (PE) Linux Host Extension (ELF) Ring 0 Linux Kernel SQLPAL
7. IO Subsystem A A B B IO Subsystem A A B B C D C D Synchronous IO Asynchronous IO Wait IO Completion Issue IO
10. int epoll_wait( int epfd, struct epoll_event *events, int maxevents, int timeout ); int io_getevents( aio_context_t ctx_id, long min_nr, long nr, struct io_event *events, struct timespec *timeout );
11. https://twitter.com/axboe http://kernel.dk/io_uring.pdf
13. ThreadWaitContext - m_conditionVariable - m_waitInfos[] - m_mutex - m_signaledObjectIndex WaitableObject - m_lock - m_waitQueue (list of WaitInfo) Event - m_signalState Semaphore - m_currentCount - m_maximumCount WaitInfo - m_waitContext* (ThreadWaitContext) - m_parentObject* (WaitableObject)
14. https://lkml.org/lkml/2019/7/30/1399
15. Challenges - Additional Reading • SQL Server on Linux: How? Introduction https://cloudblogs.microsoft.com/sqlserver/2016/12/16/sql-server-on-linux-how-introduction/ • Blog posts on SQL on Linux internals https://blogs.msdn.microsoft.com/bobsql/tag/sql-server-on-linux/