SQL Server Performance Forum – Threads Archive
How to set memory for SQL and OLAPHello, Suppose total RAm Memory in a server is 16GB. In that ,SQLserver is configured with max memory of 15 GB leaving aside 1 GB for OS.( My understanding is SQL Server and OLAP server are 2 different entities and have their own memory requirements and with this settings i assume the OLAP Server would use the available of the remaining 1 GB and the available virtual memory. Please let me know how to go about reconfiguring it. If my understanding is not correct, how we can set the memory for OLAP now.Then point me out how the sql server and OLAP will use their memory while running,whether it will parallely share it? Thanks in advance. Regards
http://www.sql-server-performance.com/olap_performance.asp and KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;295443 for you reference. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.