Symptom
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."
Resolution
The error can arise when there's not enough memory available, but the error is more likely to occur when the Web Server shares the same machine as the SQL and SSAS servers. The reason for this is, the latter two servers 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:
Production Environment
| 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 properly configured, then each server will consume as much available memory as possible. This causes problems in a shared environment, as the servers will compete each other for memory.
When this issue occurs, you may still find the memory usage is low in Task Manager. Please be aware that memory usage from the Task Manager may not accurately reflect SQL and SSAS memory consumption as those servers don't accurately report their usage to the OS.
To properly restrict the memory of your SQL and SSAS servers, please review the first part of the Kepion Setup Guide.