DBCC (Level 1)

Installing SQL Server

Installing SQL Server
DBCC (Level 1)
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 In Use
  Procedure Cache Size (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.