SQL Server 2012 notes Sharing-5: Understanding Sqlos

Describe

Sqlos is a separate application layer, located at the lowest level of the SQL Server database engine, and SQL Server and Reporting services are running at the top level. Sqlos between the Windows operating system and SQL Server.

Why Develop Sqlos

earlier versions of SQL Server use a thin interface layer between the storage engine and the actual operating system through which SQL Server can invoke the operating system to perform memory allocations, plan resources, thread and work management, and synchronize objects. However, services in SQL Server that require access to these interfaces can be located in any part of the engine. SQL Server needs to manage memory, scheduler, synchronization objects, and so on, so the task becomes more and more complex. instead of having each part of the engine support the added functionality, Microsoft designed a separate application layer to manage all SQL Server-specific operating system resources.

Architecture diagram

650) this.width=650; "title=" clipboard "style=" Border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clipboard "Src=" Http://img1.51cto.com/attachment/201406/8/639838_14022122307AdI.png "height=" 409 "/>

Terminology interpretation

Memory Manager RAM Management

Scheduling plan

Synchronization synchronization

Hosting API Host API interface

Deadlock Monitor Deadlock monitoring

Resource Monitor Resource monitoring

Lazy writer delays writing

Scheduler Monitor Monitoring scheduling

Storage Engine Storage Engines

Buffer pool Buffers

Query compilation and execution engines querying the compilation and execution engine

Protocols protocol

External Component External components

Learning Resources

SQL Server's unique task scheduling algorithm "Sqlos"

Http://www.cnblogs.com/lyhabc/archive/2012/10/17/2728724.html

Sqlos-unleashed

Http://blogs.msdn.com/b/slavao/archive/2005/02/05/367816.aspx

Set of new features in SQL Server 2005 enabled by sqlos& #160;

Http://blogs.msdn.com/b/slavao/archive/2006/04/12/575185.aspx

SQL Server Sqlos

Http://blogs.technet.com/b/josebda/archive/2009/03/30/sql-server-2008-sqlos.aspx

This article from "Zeng Hung Xin Technical column" blog, declined to reprint!