SQLPAL architechture

Question

SQLPAL architechture

sakuraime 2,341

I come across the following link

https://cloudblogs.microsoft.com/sqlserver/2016/12/16/sql-server-on-linux-how-introduction/

and may I know the following architecture also apply to sql server 2017 and sql server 2019 on WINDOWS ??

And may I know what SQL operation will go through SOSAPI , and what other operation need "Hosted windows API " ..NT USER MODE ???

1 answer

Your answer

Answer 1

m 4,276

Hi @sakuraime ,

and may I know the following architecture also apply to sql server 2017 and sql server 2019 on WINDOWS ??

Yes.

And may I know what SQL operation will go through SOSAPI , and what other operation need "Hosted windows API " ..NT USER MODE ???

According to your doc.,summary as next:
Operations go through SOSAPI: All the subsystems like storage, network, or resource management...

Operations need Hosted Windows API: Code without SOS direct APIs they will either go through a hosted Windows API (like MSXML) or NTUM (NT User Mode API – this is the 1500+ Win32 and NT syscalls)

BR,
Mia

If the answer is helpful, please click "Accept Answer" and upvote it.

sakuraime 2,341 Reputation points

2020-11-07T01:22:31.547+00:00

"they will either go through a hosted Windows API (like MSXML) " <- which means if the user write some query like "select ...for xml path...." which will go through hosted Windows API
which is inside the SQLPAL ??????

what actually is NTUM ?? how it's related to SQL TSQL ?? Any more example that SQL server TSQL will use use Windows Host API ?

So SQLPAL = host windows API + NT User mode + SOS DIRECT API + *Managers + SOSv2

Host Extension and integration is independent for windows and Linux ?
m 4,276 Reputation points

2020-11-10T05:51:33.067+00:00

Do you have one lab to have a test? No test just ask after your read one doc.?

Share via

SQLPAL architechture

1 answer

Your answer