MS SQL Server Nature on memory Consuming

Question

Can You please explain the MS-SQL Server Nature on Memory Consuming ?

Answer 1

SQL Server likes to keep memory in cache, so it serve queries faster. So essentially, when you use SQL Server, the memory consumption will go up until it hits the configured limit, or the OS says that there is no more memory available. And SQL Server will keep this memory allocated, as long as it can. But if the OS says that there is memory pressure, SQL Server will yield memory and decrease its consumption.

Answer 2

Hi @Srinivas Syamala，

SQL Server dynamically acquires and frees memory as required. Typically, an administrator doesn't have to specify how much memory should be allocated to SQL Server, although the option still exists and is required in some environments.

One of the primary design goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. SQL Server builds a buffer pool in memory to hold pages read from the database.

Details please check: Memory management architecture guide

Regards，

Zoe Hui

---

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