dbcc listoam output has changed substantially.
The space state message printed in the old dbcc listoam output is now available as a new column spacestate in sysobjects.
dbcc tablealloc output has changed.
dbcc page’s output has changed to print partition ID instead of object ID.
dbcc checktable output on a partitioned table has been changed to provide partition level information.
dbcc checktable/tablealloc/indexalloc has new syntax for partition support.
Output of "REORG RECLAIM_SPACE
<tablename> with RESUME" has changed.
reorg rebuild will fail with message 11051 when table is in use by other tasks.
Output of sp_dbcc_faultreport has been enhanced to show partition ID information.
The hostname, program_name, hostprocess and cmd columns in sysprocesses are changed to varchar(30) and made nullable. Select from sysprocesses will return NULL for these columns instead of space for system tasks.
The “first” column in sysindexes is moved to “firstpage” column in syspartitions.
The name column in syspartitions has been changed from index_name+_+tableid to index_name+_+ptn_id for partition table with indexes.
The basic costing of the optimizer now includes CPU cost.
Parallel costing is done only on base tables/indexes that are greater than 20 pages.
For information about trace flags and diagnostics information, see the Query Processor Guide.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
