SQL Server 2022 : Memory Management

SQL Server, since it works with data, uses a lot of memory on your system.
And it's important to know how to configure that so that you can make sure that A; SQL Server gets the resources it needs to function,
but also B; prevent SQL Server from stepping on other things that might be running on your machine.
So we're going to have a brief look at how to configure the memory SQL uses and, kind of, a talk about what that all entails.
So in Management Studio here, if you right click on a particular instance, select "Properties,"
you're going to get the server properties dialog and there are a lot of pages to this dialog.
We're going to focus on some of these in some other lessons, but right now, what I want to show you is the memory page.
So the memory page, very simplistic on its surface. There are four different options.
First one here is the minimum server memory, which by default is set to zero.
The second option, maximum server memory, by default set to this ungodly large number.
This is essentially the max of an integer.
So it's essentially all the memory you could possibly have on your machine.
And when SQL Server starts up, it will grab some chunk of your physical memory between, in this case, zero and two billion.
And in general, that's okay because usually, and this is not always the case, SQL Server is running on its own machine in an environment where you've given it resources and you're like SQL Server do what you need to do to make yourself happy.
But sometimes you also have, say, a web server on the same machine or some other sort of application on the same machine that also require memory.
So this is what allows you to tweak how much SQL gets.