The following Monitoring and Diagnostic Access (MDA) tables have new columns:
monEngine
monCachedObject
monProcessObject
monCachedObject now tracks cached pages based on indid and partitionid.
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 a 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.
