DBCC (Level 1)
New Information - SQL Server 2000 SP3.
|SQL Server 6.x||SQL Server 2000|
|DBCC DBREINDEX used the SORTED_DATA and SORTED_DATA_REORG clauses. The SORTED_DATA clause eliminated the sort performed when a clustered index was created and physically reorganized the data. The SORTED_DATA_REORG clause eliminated the sort performed when a clustered index was created.||Removed; no longer supported. Remove all references to either the SORTED_DATA or the SORTED_DATA_REORG clauses of DBCC DBREINDEX and replace with references to the DROP_EXISTING clause of CREATE INDEX.|
|DBCC SHRINKDB either returned the minimum size to which a database could shrink, or shrank the size of the specified database to the specified value.||Removed; no longer supported or available. Remove all references of DBCC SHRINKDB and replace with references to DBCC SHRINKDATABASE. Consider shrinking databases automatically by using the AUTO_SHRINK option of ALTER DATABASE.|
|DBCC MEMUSAGE provided detailed reports on memory use.||Removed; no longer supported or available. Remove all references of DBCC MEMUSAGE and replace with references to these Performance Monitor counters.|
|Performance Monitor object name||Performance Monitor counter name|
|SQL Server: Buffer Manager Object||Procedure Cache Pages|
|SQL Server: Cache Manager Object||Procedure Cache Hit Ratio|
|Procedure Cache Pages|
|Procedure Cache Object Counts*|
* These counters are available for various categories of cache objects including ad hoc sql, prepared sql, procedures, triggers, and so on.