Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #2151
| From | Erland Sommarskog <esquel@sommarskog.se> |
|---|---|
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: Limiting memory usage |
| Date | 2022-07-05 09:45 +0200 |
| Organization | Erland Sommarskog |
| Message-ID | <XnsAECB6345F77FBYazorman@127.0.0.1> (permalink) |
| References | <20220505124052.0ca7954a09edb5ff9ad84a0f@g{oogle}mail.com> <20220704143129.09dc28f65821d135ea404649@g{oogle}mail.com> |
Anton Shepelev (anton.txt@g{oogle}mail.com) writes:
> I continue to experiment with my memory balancer, and its
> worst defect is that sometimes by decreasing
> 'max server memory' it causes the isntance to freeze and
> become unresponsive until restarted. There are three ranges
> of these setting:
>
> freeze high CPU Works OK, zero CPU
> until usage while usage while idle
> restart idle
> |--------|-------------|--------------------->
> 0 V1 V2 max server memory
>
>...
> Have you an idea how to estimate minimum working value for
> server memory, that is V2 in the diagram above?
You don't say which absolute values you are working with. What I've noticed
is that if you set "max server memory" to really low values, below 400 MB,
SQL Server will not even start.
I'm not surprised if you can set "max server memory" to higher values
and still send your server into nirvana.
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar
Limiting memory usage Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-05-05 12:40 +0300
Re: Limiting memory usage Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-05-05 13:18 +0300
Re: Limiting memory usage Erland Sommarskog <esquel@sommarskog.se> - 2022-05-05 21:28 +0200
Re: Limiting memory usage Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-05-11 12:48 +0300
Re: Limiting memory usage Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-07-04 14:31 +0300
Re: Limiting memory usage Erland Sommarskog <esquel@sommarskog.se> - 2022-07-05 09:45 +0200
Re: Limiting memory usage Anton Shepelev <antonius@freeshell.de> - 2022-07-05 12:16 +0300
Re: Limiting memory usage Erland Sommarskog <esquel@sommarskog.se> - 2022-07-05 21:27 +0200
Re: Limiting memory usage Anton Shepelev <anton.txt@gmail.com> - 2022-07-06 00:45 +0300
csiph-web