Recommendations for Reporting database deployment

The reporting database server deployment has the following recommendations:
  • Symantec recommends to have the reporting database on 64 bit Windows Server and 64 bit SQL Server.
  • If you have a single disk and disk controller, reporting database operations such as reporting sync, report purge or archival consume disk input/output (I/O), which can potentially affect the performance. If you have multiple high performance disks with separate disk controllers. SQL Server spawns one writer thread for each physical disk. This improves the performance of I/O operations.
  • Symantec recommends to have multiple high performance disks with separate disk controllers to store the SQL data, SQL Log, and Temp DB components.
    All the disks should be high-speed: 15,000 RPM drives.