Author: SSWUG Research

Community

FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statement

Consider the following scenario. You start the SQL Server 2000 service. You execute the BACKUP DATABASE statement or the BACKUP LOG statement at least one time. In this scenario, CPU utilization may approach 100 percent. After approximately 15 minutes or less, CPU utilization decreases.

Community

SQL 2005 Maintenance Wizard Part 1

(Don Schlichting) There are a number of database housekeeping tasks that should be done on a regular basis to insure SQL performance and data integrity are optimized. Backing up the database, reorganizing data and index files, compressing the data file, updating the index statistics, and performing