MS SQL Server Nature on memory Consuming

Srinivas Syamala 20 Reputation points
2023-08-25T11:13:18.2333333+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,654 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 100.8K Reputation points MVP
    2023-08-25T21:13:22.5266667+00:00

    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.

    0 comments No comments

  2. ZoeHui-MSFT 32,506 Reputation points
    2023-08-28T06:50:15.9866667+00:00

    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.

    0 comments No comments