Memory Usage Commserver

Hi ​@Egor Skepko , 
Good day , 

Q: Please find my comments below. What would be the best way to reduce the overall RAM usage? Is 31 GB allocated to SQL Server too much?

A: Based on the information you provided, 31 GB allocated to SQL Server is not excessive. As you mentioned, the general recommendation is to configure SQL Server to use up to 50% of the available physical memory on a CommServe. With 80 GB of RAM, allocating approximately 31 GB to SQL Server is within the recommended range. It is also normal to see datacube.exe (indexing) consuming a significant amount of memory, especially if indexing operations are active. Commvault is designed to utilize available memory to improve indexing and search performance.

Q: What would happen if I reduced the amount of RAM allocated to indexing or to SQL Server? Are there any potential performance impacts or risks that I should be aware of?

A: I would not recommend reducing the memory below the recommended values unless there is a specific reason and the environment has been thoroughly assessed. Reducing SQL Server memory may result in: Slower database operations. Increased disk I/O and paging. Longer query execution times. maybe under a heavy workloads the CS become down.
Reducing the memory reserved for indexing may result in: Slower indexing performance. Longer indexing jobs. Reduced search and content indexing performance, particularly in larger environments. If your CommServe is consistently operating under high memory utilization and you are not experiencing any performance issues, this is generally acceptable, as Windows and Commvault efficiently utilize available memory. If resource utilization continues to increase over time or you observe performance degradation, my recommendation would be to plan for a hardware upgrade by increasing the available RAM. If the CommServe is running on physical hardware, you may also consider a hardware refresh as part of your capacity planning.

Overall, I would avoid reducing the current memory allocations unless there is clear evidence that they are oversized for your workload.

Thanks & Regards,
Ramadan