SQL Server memory-related terminology

Terminology 1,

Virtual address space

It is the maximum address space that an application can access, the 32-bit machine is 4G (2^32), and the data in the virtual address space is not necessarily in physical memory. May be in the cache file.

Terminology 2,

Physical Memory physical

The storage space provided by the inner-intentional slice.

Terminology 3,

Reserved memory reserved

An application can leave a block of addresses for future use, and if an address is reserved by another program, you will receive an out-of-bounds error when you visit it.

Terminology 4,

Committed Memory Commit RAM

The memory (commit) of the previous reservation (reserved) is submitted for use. This means that the space is formally applied in physical memory.

Terminology 5,

Shared memory

Windows provides a mechanism for sharing memory between processes and operating systems. Shared memory can be defined as memory that is visible to more than one object, or that exists in multiple processes

Space.

Terminology 5,

Private bytes

A non-shared portion of the space that a process submits.

Terminology 6,

Working Set

The portion of the address space of a process that is stored in physical memory.

Terminology 7,

Page fault

Missing pages Interrupt

Terminology 8,

System Working Set

Working set of the system

It embraces:

A

System cache Systems Cache, save file pages to improve IO speed.

B

Non Paged Pool non-paging zone, unlike the system cache, it is a long-standing memory. cannot be paged out.

C

Paged Pool page Swap area, system space can be called into the system working set of virtual memory area.

D

The stack saves the process that the process runs, the call address of the function, and the value of the parameter.

SQL Server memory-related terminology