Download the complete documentation in PDF

Skip to end of metadata
Comment: Corrected links that should have been relative instead of absolute.
Go to start of metadata

Database Configuration

Overview

This section will help you prepare your database ready for use with FusionAnalytics.

Visit Microsoft's SQL Server website for more information on the different versions and details on how to buy. You can also use the free Express Edition, see below for more information.

Please note that version 1.0.0 of FusionAnalytics currently only supports Microsoft SQL Server 2005, 2008 and 2008 R2.

Microsoft SQL Server Express

The Express Edition is a free version of Microsoft's SQL Server. It still uses the same core database engine, but on a smaller scale.

There are no limitations on the number of databases or users that can be set up, but there are constraints on the size of each individual database, and the overall performance of the system.

Constraint

Maximum Value

Database size

4GB for Express 2005 and 2008. 10GB for Express 2008 R2

Memory used

1 GB

CPUs used

1

(warning) The maximum database size applies per database, excluding log files.

Download for free: Microsoft SQL Server 2008 R2 RTM - Express with Management Tools.

Database size

The following tables should give you a rough idea of how big your database will be. This information is for Microsoft SQL Server in simple recovery mode (if you follow the Quick Start Guide you will configure your database in this way).

  • High resolution data is all information stored in the database from every sample taken by FusionAnalytics.
  • Low resolution data is data that has been quantized to reduce the database size.

See Scaling and Quantization for more information on data quantization or Application Configuration (FADC) to find out how to control the length of time this information is stored.

The above figures are only an estimate based on test data. Using longer URLs, more parameters, more database requests and other details will change the results. The average URL used in the above data was 60 characters long from http:// to the file extension with an average of 1.3 JDBC requests per standard request.

Next Steps

Prepare and Configure your database for FusionAnalytics:

Configure Network Settings

Create a New Database Login

Create a New Database


Once your database is ready to use, visit the installation guide to get started.