Partitioned Tables

The partitioned tables report shows you the tables in your SQL Server database that are partitioned.

Double clicking on the pie chart of the partition in the list at the bottom brings up the Partitioned Table Advisor. The Partitioned Table Advisor will show you the partitioning ranges, and the percent column shows the percentage of the entire table that it contained in that partition.