sysindexes has the following new columns:
partitiontype
conditionid
status3
The following sysindexes columns are now maintained in syspartitions:
doampg
ioampg
first
root
These columns display 0 after you upgrade. The base_partition column is now obsolete and displays 0 after you upgrade.
The syspartitions table is renamed to sysslices during the upgrade process, then the new table is empty and unused.
syscomments gains a new column called partitionid.
systabstats gains the following new columns:
partitionid
plldegree
statmoddate
sysstatistics gains a new column called partitionid.
There is a new type of object called a partition condition object, which has a row in sysobjects. A partition condition object is the representation of a tree for the partition table boundary conditions. The tree is stored in sysprocedures.
sysobjects has the following new columns:
identburnmax
spacestate
erlchgts
sysstatistics stores the data change counters with formatid=108. The space required by sysstatistics increases due to the additional rows stored.
Most system catalogs have been converted to the datarows-locking scheme. However, DDLs continue to use the table-level locks. The row locking of the system catalogs can require an increase in the configuration parameter number of locks, depending on the DDLs in the application.
The system catalogs converted to the datarows-locking scheme do not have a clustered index with indid equal to 1. The clustered indexes now have index ID greater than or equal to 2.
