Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Administering Websense Databases > Can I use SQL Server 2008 R2 Express?
Can I use SQL Server 2008 R2 Express?
Administering Websense Databases | Web, Data, and Email Security Solutions | v7.6.x - v7.8.x
Microsoft SQL Server 2008 R2 Express is bundled into the Websense TRITON Unified Installer.
Regardless of the resources available on the machine hosting the database engine, Microsoft limits the resources that SQL Server 2008 R2 Express can use to:
*
*
*
This results in practical limits on the amount of data that can be stored in SQL Server 2008 R2 Express, while still maintaining acceptable performance when generating reports and processing log data. For best performance, no more than 30 GB of data should be stored in SQL Server 2008 R2 Express across all Websense modules. The sizing recommendations below are based on this assumption.
For an explanation of particular demands that Websense reporting places on available memory, see Other factors that affect the performance of Websense reporting.
Use the charts below to see how much data you can store using SQL Server Express based on the Websense module or modules you are using. You can then determine if that limit still meets your data retention requirements. If so, you can use SQL Server 2008 R2 Express.
Note 

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Administering Websense Databases > Can I use SQL Server 2008 R2 Express?
Copyright 2016 Forcepoint LLC. All rights reserved.