Introduction
After completion of Microsoft SQL Server 2005 installation, it is recommended to perform some important checking and optimization.
Description
Database Compatibility Level After Upgrade
After an upgrade, SQL Server 2005 automatically sets the database compatibility level to the level of the previous version of SQL Server. Therefore, if you upgrade from SQL Server 7.0 through SQL Server 2000 and then to SQL Server 2005, the compatibility level will be set to SQL Server 2000.
To check the compatibility level of your database, you can use the following script: sp_dbcmptlevel [<databasename>]. The compatibility level for database in SQL Server 2005 should be 90.
To set the compatibility level of your database, you can use the following script: sp_dbcmptlevel [<databasename>],90
Update statistics
To help optimize query performance, we recommend that you update statistics on all databases following upgrade. Use the sp_updatestats stored procedure to update statistics in user-defined tables in SQL Server 2005 databases
Update usage counters
In earlier versions of SQL Server, the values for the table and index row counts and page counts can become incorrect. To correct any invalid row or page counts, we recommend that you run DBCC UPDATEUSAGE on all databases following upgrade
Related documents