Skip Navigation
  1. BlackBerry Docs
  2. BlackBerry AtHoc
  3. 7.15
  4. BlackBerry AtHoc Capacity Planning Guidelines
  5. Software performance configuration
  6. Database server recommendations
  7. SQL common criteria and C2 auditing
  8. SQL TempDB

SQL TempDB

BlackBerry AtHoc
 is a heavy user of TempDB storage.
A good starting point for TempDB configuration is:
  • 4 data files, 1 GB each
  • 1 log file, 512 MB
This is the initial configuration set by the 
BlackBerry AtHoc
 installer MSI.
The TempDB files should be stored either with the database transaction logs, or on a volume with equivalent or better performance to the transaction logs volume. Some VMs have the option for a temporary drive, which is an SSD. Such a temporary drive is the recommended place to host temporary DB files.