SQL Server memory Usage degradation issues

SQL Server This program is not like memory this thing. So it's memory usage down, must be someone else to rob. The consequence of this is that SQL Server becomes

Very slow. How can we make this thing less prone to happening?

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

Method 1,

Lock page in memory method

In this way, SQL Server is given a dead-face memory capacity. The general program does not have the ability to grab its memory. Windows can still grab its memory, and the Setup method is as follows

1. Running Gpedit.msc

2. Security settings--local policy

3. Double-click Lock Memory page

4. Adding user groups

5. Close Group Policy and restart the SQL Server service.

Method 2,

Using sp_configure to set the max server memory value for SQL Server, make sure that SQL Server does not use too much RAM to avoid windows feeling memory pressure.

SQL Server memory Usage degradation issues