Self-Hosted Database Setup

For organizations that require complete control over their data, LoadGen Insight supports self-hosted database deployments.

Supported Databases

LoadGen Insight can store data in the following database systems:

| Database | Minimum Version |

|----------|-----------------|

| Microsoft SQL Server | 2016 or later |

| SQL Server Express | 2016 or later (4GB limit) |

Prerequisites

• SQL Server instance with appropriate permissions
• Network connectivity between LoadGen components and database
• Sufficient storage for your data retention requirements

Installation Steps

1. Prepare SQL Server

Create a new database for LoadGen Insight:

`sql

CREATE DATABASE LoadGenInsight;

GO

`

Create a service account with appropriate permissions:

`sql

USE LoadGenInsight;

CREATE USER [LoadGenService] FOR LOGIN [domain\loadgenservice];

ALTER ROLE db_datareader ADD MEMBER [LoadGenService];

ALTER ROLE db_datawriter ADD MEMBER [LoadGenService];

GO

`

2. Configure LoadGen

1. Open LoadGen Configurator

2. Navigate to Database Settings

3. Enter your SQL Server connection details

4. Test the connection

5. Apply the configuration

3. Verify Installation

Run a test workload and verify data appears in your dashboard.

Storage Planning

Estimate your storage requirements based on:

• Number of concurrent users per test
• Frequency of tests
• Data retention period
• Number of measurements per transaction

Rule of thumb: Approximately 1 MB per 1,000 transactions stored.

Backup Recommendations

• Schedule regular database backups
• Test restore procedures periodically
• Consider point-in-time recovery for critical data