We are using MS SQL Server database for our Pega application and currently we have allocated 85% of total memory to SQL Server. And currently database server overall utilization goes up to 95% in production environment.
We would like to know what is the Pega support recommendation or best practice to configure memory for MS SQL Server database which is being used by Pega application?
Current memory settings:
Database Server total memory (RAM) - 56GB
Memory allocated to MS SQL Server - 48GB
Total server memory utilization - ~95%
***Edited by Moderator: Pooja Gadige to add capability tag***