Technical Library
|
Support
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
Applies to:
Web Filter, Web Security, and Web Security Gateway (Anywhere), v7.6.x - 7.8.x
Data Security, v7.6.x - v7.8.x
Email Security Gateway (Anywhere), 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
:
1 GB of RAM
1 physical CPU
10 GB of data per database
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
Standalone Data Security installations can support up to 5000 users with SQL Server 2008 R2 Express.
Users
Web*
Web and Data
Data and Email**
Web, Data, and Email
2000+
Do not use
Do not use
Do not use
Do not use
2000
45 days
30 days
Do not use
Do not use
1500
60 days
45 days
Do not use
Do not use
1000
90 days
60 days
Do not use
Do not use
750
4 months
3 months
Do not use
Do not use
500
6 months
4 months
30 days
Do not use
250
1 year
8 months
60 days
30 days
100
1 year+
1 year
5 months
3 months
* Web Security: Actual size is based on Web requests processed per day, which can be extrapolated from the peak requests per second in your network. If you are not able to determine these numbers, Websense has found that the ratio of users to their peak number of Web requests per second (as opposed to average number per second) is 10 to 1. This is an acceptable ratio to use for the purposes of estimating the number of users that this traffic represents in the average network. Note that this calculation is based on a standard curve distribution of traffic throughout the day, where the peak is mid-day and there is almost no traffic throughout the night.
** Email Security: Actual sizing is based on total email messages sent and received per day, including spam. Websense has found that an estimate of 1 message per user per minute (including spam) is an acceptable estimate for the purposes of estimating the email volume generated for any given number of users.
Administering Websense Databases
> Can I use SQL Server 2008 R2 Express?
Copyright 2016 Forcepoint LLC. All rights reserved.