SharePoint 2013数据库服务器使用的物理内存为97% [英] SharePoint 2013 Database server is using 97% memory of physical memory
问题描述
SharePoint 2013数据库服务器使用的物理内存为97%(32 GB).我已经将使用98%的内存将SQL Server的内存使用量降低到28GB.
谁能帮我减少服务器的内存使用量?
如何调整服务器并提高性能?
任何帮助将不胜感激.
谢谢
OK29
您是否部署了任何自定义功能(例如计时器作业)来运行大量SQL查询和请求?
减少SQL查询的数量并比较结果.
此处是有关SharePoint服务器场中SQL Server最佳做法的文章:
https://technet.microsoft.com/zh-cn/library/hh292622.aspx?f=255&MSPPError=-2147217396
最好的问候,
Linda Zhang
>
Hi,
SharePoint 2013 Database server is using 97% memory of physical memory(32 GB). I already reduces the SQL Server Memory usage to 28GB STILL USING 98% of memory.
Can any one help me out how to reduce the memory usage of server?
How to tune the server and improve the performance?
Any help would be greatly appreciated.
Thank you,
OK29
Hi OK29,
Have you deployed any customizations such as a timer job to run an amount of SQL queries and requests?
Reduce the number of SQL queries and compare the results.
Here is an article about best practices for SQL Server in a SharePoint server farm:
https://technet.microsoft.com/en-us/library/hh292622.aspx?f=255&MSPPError=-2147217396
Best Regards,
Linda Zhang
这篇关于SharePoint 2013数据库服务器使用的物理内存为97%的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!