You must run the following SQL Admin Toolset tools under the Administrator account for proper functionality:
|
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.
Partition Generator evaluates partitions on all editions of SQL Server 2016 SP1 and above. SQL Server 2016 RTM is not supported because partition evaluation is not allowed on that version.
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.
| | | | | | | |