It would be greatly appreciated if DB scripts could be optimized to not use all the available SQL memory. Thank you.
in-memory tables like last time, the scripts need to be optimized so as not to use all available sql memory.in-memory tables like last time, the scripts need to be optimized so as not to use all available sql memory.in-memory tables like last time, the scripts need to be optimized so as not to use all available sql memory.in-memory tables like last time, the scripts need to be optimized so as not to use all available sql memory.in-memory tables like last time, the scripts need to be optimized so as not to use all available sql memory.
First because SQL Server needs memory for performance, and to get it clear: its not the scripts which are stored in the memory buffer cache, its the pages.
If the SQL Server service is taking to much memory, you can configure the maximum memory settings on the instance level.
Top Comments