SQL Server 2008 R2 occupies more and more memory. How can this problem be solved?

Cause analysis

It may be because many servers are not restarted or the database causes the sqlserveragent and mssqlserver services to occupy a large amount of memory. You can simply restart the server.
,
Use the task plan to regularly execute the following batch processing:

Net stop sqlserveragent
Net stop mssqlserver
Net start mssqlserver
Net start sqlserveragent

In this way, the memory can be restarted and released after a period of time.