Author: Joyce Zhou
When connecting to Kepion, an error message appears with the message: Sorry, the service is temporarily unavailable. Please check your connection or try again later.
This can happen when there's not enough memory available. It is more likely to occur when the Web Server shares the same machine as the SQL and SSAS servers, as the latter two will consume all the available memory if not properly restricted.
Typically, we recommend a minimum 14 GB memory for a production shared environment. The recommended memory allocation should be:
|Number of Users||Web Server||SQL Server||SSAS Server|
|Small < 10||2+ GB||4+ GB||4+ GB|
|Medium < 50||4+ GB||6+ GB||6+ GB|
|Large > 50||6+ GB||8+ GB||8+ GB|
If the SQL/SSAS memory thresholds are not configured, then each server will consume as much available memory as possible. This will cause problems in a shared environment, as the servers will fight each other for memory.
When this issue occurs, you may still find the memory usage is low in the Task Manager. Please be aware that memory usage from the Task Manager may not accurately reflect SQL and SSAS memory consumption, as they don't accurately report their usage to the OS.
To properly restrict the memory of your SQL and SSAS servers, please review these sections from the Kepion Setup Guide: