Page tree

The Partition Generator tool helps you create and manage SQL Server table partitions, which provides better data management for large tables. A large, unpartitioned table can cause performance issues, blocking issues, costly backups, and overall scalability issues as the table continues to grow. Partitions can help solve these problems by splitting the data into smaller, more manageable segments.

How the Partition Generator works

The Partition Generator tool allows you to quickly determine whether a table is partitioned or needs partitioning. You can create the necessary partitions and specify the appropriate data ranges or change existing partitions by merging or splitting data ranges.
Before using the Partition Generator tool, it is important to know that table partitioning is supported by SQL Server 2005 or later. For more information, see Microsoft SQL Server Books Online.

By default, the Partition Generator tool connects to the specified SQL Server instances using the credentials of your currently logged on Windows account, and then collects partition information about each table. The Partition Generator tool uses partition functions and partition schemes to define how the data should be split.

Use the Partition Generator tool

To use the Partition Generator:

  1. Open the IDERA SQL Admin Toolset Launchpad, and then click Partition Generator.
  2. Specify the SQL Server instance or server group that contains the database you want to partition. To specify multiple SQL Servers, separate each instance name with a semicolon.
  3. Click Get Partition Information.
  4. To see only partitioned tables, select that option on the Table pane.
  5. If you want to create a partition, complete these steps:
    1. In the Partition Details column, click Create for the table you want to partition.
    2. On the Partition Information window, specify the appropriate partition settings.
    3. To add a new data range, click Add new, and then type the range values in the new grid row. Ensure the range values are in ascending order and can be converted to the SQL data type of the partition column.
    4. Click OK.
  6. If you want to edit a partition, complete these steps:
    1. In the Partition Details column, click Edit for the partitioned table you want to update.
    2. On the Partition Information window, change the appropriate partition settings.
    3. To add a new data range, click Add new, and then type the range values in the new grid row. Ensure the range values are in ascending order and can be converted to the SQL data type of the partition column.
    4. Click OK.
  7. Click OK.

 

IDERA SQL Admin Toolset delivers 24 essential administration tools. Learn more > >