Help Center
Choose product document...
Veeam ONE 9.5 Update 4
Deployment for Large-Scale Environments

Step 5. Run Partitioning Scripts

To improve Veeam ONE database performance, create partitioned tables and indexes:

  1. Download an archive with script files from this KB.
  2. Open the files for edit and perform the following changes:
  1. Locate the %UserName% parameter and specify instead of it name of a DB admin.

This can be sa or any domain account that has full control permissions on the Veeam ONE database.

  1. Locate %Path% parameter and specify instead of it a directory where database partitions must be created and stored.
  2. If the Veeam ONE database name is different from the default one, change the name of the database (VeeamOne) in the script.

Make sure you replace all references to the VeeamOne database in the script.

  1. Log on to the Microsoft SQL Server.
  2. Make sure that Microsoft SQL Agents are running.
  3. Execute both scripts.
  4. In the object explorer pane, expand the Veeam ONE database > Storage > Partition Schemes and Partition Functions nodes and make sure the following nodes are available:
  • Partition Schemes: Low_ps_dt, Med_ps_dt
  • Partition Functions: Low_pf_dt, Med_pf_dt

Run Partitioning Scripts

  1. Make sure that the directory with partition files includes files similar to the following:

Check Partition Files

Veeam Large Logo

Deployment Guide

Deployment for Large-Scale Environments

Monitor User Guide

Reporter User Guide

Quick Start Guide

Multi-Tenant Monitoring and Reporting

Working with Alarms

Veeam Backup & Replication Documentation

Veeam Agent for Windows Documentation

Veeam Agent for Linux Documentation

Veeam Management Pack Documentation