Current location - Health Preservation Learning Network - Healthy weight loss - How to solve the problem that SQL Server 2008 R2 occupies more and more memory?
How to solve the problem that SQL Server 2008 R2 occupies more and more memory?
These occupied memories are actually data caches. If the memory is large enough, don't delete it. Deleting it will reduce performance and efficiency.

If it must be deleted, it is essentially to limit memory overhead through maximum openness:

1, right mouse button instance->; Attribute-> internal storage

2. Set the maximum memory.

3、