Overview
Definitions
BlackBerry AtHoc compute requirements
- Virtual environment
- Physical environment
Storage requirements
Network requirements
- Desktop App bandwidth requirements
Software performance configuration
- Database server recommendations
  - SQL common criteria and C2 auditing
    - SQL max instance memory
    - SQL TempDB
BlackBerry AtHoc application configuration recommendations
Platform configuration requirements
- Database server
- Application server
BlackBerry AtHoc performance tests
BlackBerry AtHoc performance test result summary
- Virtual environment
- Physical environment
Data encryption
- 128-bit TDE
- 256-bit TDE
BlackBerry AtHoc test metrics
- Virtual environment
- Physical environment
BlackBerry AtHoc Customer Support Portal
Documentation feedback
Legal notice

SQL max instance memory

SQL should have a RAM cap put on the instance to avoid memory contention with the host operating system. In general, the SQL instance RAM should be set to 80% of the total system RAM.

If SQL memory consumption is left unconstrained, it will gradually consume all available memory, leaving none for the operating system to perform additional tasks. This can lead to memory paging and RAM being pulled away from SQL by the OS. Both conditions can affect SQL performance.

Click the following link to learn how to cap SQL memory: https://technet.microsoft.com/en-US/library/ms191144%28v=SQL.105%29.aspx.

Section:

SQL common criteria and C2 auditing