Hello. Answer, please, if anyone knows: Microsoft SQL Server 2005 installed. After a restart, it eats about 100 meters of RAM. Then, when the mass of requests to it begins, it begins to take up more and more space in the RAM. And over time, as I hoped, it does not free up memory.
Question: why is this happening? And, if these malicious processes occur in it, then how to deal with them?
Anton Mukhin Anton Mukhin
4.362 7 golden marks 42 silver marks 89 bronze marks
|
1 answer
This is normal. You must specify a memory limit for the server. Read the documentation for MS SQL Server, section on managing memory settings .
cy6erGn0m cy6erGn0m
18.9k 24 silver marks 33 bronze marks
- Thank you very much. Could you please answer what the SQL server allocates all this memory. - Anton Mukhin
- oneI'm not an MSSQL Server specialist, but, for example, Oracle uses data caching, indexes, to increase the size of the visible "window" when processing tables, to perform stored procedures (Oracle uses PLSQL very actively even at the lowest level). I think the MSSQL server also has where to put the memory. If we summarize all this, then we can say in one word: optimization. - cy6erGn0m
- Everything is clear, thank you. - Anton Mukhin
|