Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Administering Websense Databases > Reporting database specifications and recommendations
Reporting database specifications and recommendations
Administering Websense Databases | Web, Data, and Email Security Solutions | v7.6.x - v7.8.x
The performance of Websense reporting solutions is heavily dependent on the SQL Server, and the configuration of its underlying resources. The more you invest in the system, the better it will perform.
For optimal results, host the reporting databases on Windows Server 2008 R2 Enterprise Edition and SQL Server 2008 R2 Enterprise Edition.
Also consider the factors that follow when designing your database system.
Hardware specifications
Use hardware that meets or exceeds Microsoft's recommended (not minimum) hardware requirements for SQL Server.
Microsoft SQL Server 2012:
Microsoft SQL Server 2008 R2:
Microsoft SQL Server 2008:
Microsoft SQL Server 2005 SP4 (Web Security v7.6.x or v7.7.x only):
The reports that administrators generate often require that SQL Server be capable of loading, summarizing, and processing large amounts of data across multiple physical databases. Even if your organization doesn't run complex reports, if there are multiple reporting administrators, the system may frequently be asked to generate several reports concurrently. This places high demands on system memory. As a result, increasing RAM may provide noticeable performance improvements.
Keep in mind that the operating system version and/or the version of SQL Server may limit the amount of physical RAM that can be used by the system. For example, Windows Server 2008 Standard Edition supports SQL Server 2008 running with a maximum of 32 GB of RAM, no matter how much is available in hardware.
Consult your operating system and SQL Server documentation to ensure that you utilize the maximum physical RAM possible in your chosen system.
See Other factors that affect the performance of Websense reporting for guidance on how the memory demands of Websense reporting may increase or decrease based on how you use it.
Disk considerations
Because database operations are often I/O-intensive, a faster, dedicated disk can improve how the database performs. Use high-performance disks whenever possible to ensure optimum database operation.
SQL Server performs better when there is minimal disk contention. For best performance, place tempdb files, reporting database files, and log files on separate physical drives with dedicated controllers. Follow SQL Server recommendations for installing and configuring SQL Server.
RAID controllers provide disk redundancy and can increase disk throughput by spreading I/O activity across multiple physical disks. If you have a high-demand system, for peak performance, use a RAID 10 configuration managed by a hardware-based RAID controller. (For systems with a lower I/O profile, RAID 5 may provide sufficient performance at a lower cost.)
For best performance:
This means separate spindles or RAID arrays, not just separate logical drives.
If you are using a SAN, map the physical and logical LUNs to ensure you are reading and writing key components to separate physical drives. (This is to enable multiple parallel IO operations.)
Websense products can be deployed on virtualized systems. Be aware that the use of virtualization can affect system performance. Expect up to 25% performance degradation.
For specifics on virtualization support, see the article Virtual Machine Support, available from support.websense.com.
Note that Microsoft has its own support guidelines for SQL Server, which can be found here:

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Administering Websense Databases > Reporting database specifications and recommendations
Copyright 2016 Forcepoint LLC. All rights reserved.