At ordinary times normal server CPU utilization rate is low, the footprint is much,
Only when the client queries the largest amount of data, the CPU will run, run slowly,
What reason is this?

CodePudding user response:

Database memory of so big?

CodePudding user response:

reference 1st floor aabbabababaa response:

database memory of so big?

Is, is not normal?

CodePudding user response:

The database of normal good memory,

CodePudding user response:

The

quoted zhao teacher reply: 3/f

database of normal good memory,

What to do? Add a memory bank? Still?

CodePudding user response:

Use SSMS to limit the SQL memory can
SSMS link SQL
Right-click SQL attribute
Memory
Configuration values
* * * * MB

CodePudding user response:

SQL Server itself also have a place to set up how much memory use,