Conventions on SQL Server and Windows memory usage

Source: Internet
Author: User
Tags server memory

When SQL Server frees up its own memory! In order to provide it to other programs?

--------------------------------------------------------------------------------------------------------------- -----------------------------------------------

To say this, we'll start by talking about the target server memory,total server memory in SQL Server two registers.

Total server memory refers to how much RAM is currently occupied by SQL Server,

Target server memory is how much RAM SQL Server wants to use,

When total < target SQL Server requests memory for itself, it will not stop until the two values are very close.

If Windows wants to tell SQL Server to release a little memory, Windows adjusts the size of the target Server memory so that target<total;

SQL Server knows that you can not only request space but also release a portion of it.

Conventions on SQL Server and Windows memory usage

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.