Step 5. Run Partitioning Scripts

In this article

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


    • This step is applicable only if you upgraded to Veeam ONE 11a from version 9.5 update 4 or earlier or have not applied partitioning scripts after upgrading to version 10. For new installations of Veeam ONE version 11a, partitioned tables are created automatically as a part of the installation process.
    • It is not recommended to run partitioning scripts against a database that is part of Microsoft SQL Server Always ON availability group.

    To 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