This is my learning note base on the “SQL Server Essentials for Oracle DBAs Jump Start” . Many of the screenshots are from MSFT.
SQL Server does not have granularity memory configuration like Oracle. As you can see from below screenshot, we only can configure MAX/MIN Server memory, Index creation memory and Minimum memory per query.
select * from sys.dm_os_memory_clerks
select * from sys.dm_os_sys_info
select * from sys.dm_os_sys_memory
select * from sys.dm_os_process_memory
select * from sys.dm_os_memory_nodes
SQLOS is equivalent of the PMON process in Oracle.
Oracle has 2 connection mode: See here more detail.
- Dedicate Server mode
- Share Server mode
SQL Server always use share server mode.
- SQL Server use thread model and we can configure to use fiber optionally.
- Oracle use process model on Linux but use thread model on windows.
Below is the screenshot of the SQL Server threads.
Below is the screenshot of the Oracle 12c threads on Windows Server 2012.
Below is the screenshot of the Oracle 11g process on the Linux
Here is the comparison processes between Oracle and SQL server.
To see background process from SQL Server. Session_id < 50 are the system processes.
select session_id,status,command from sys.dm_exec_requests