Summary of routine maintenance of SQL Server database (db)

The following is my daily maintenance summary, reference for attack, and constant improvement:

1. Check the CPU occupied by SQL Server. Check whether the server CPU is stable. Use the Windows Task Manager to check the CPU usage.

2. Check whether the memory used by the database is suddenly increased and whether the memory is used by the database. Check whether the maximum memory settings are reasonable.

3. Check whether the backup file is normal and whether the last backup file exists.

4. Check the disk size of the backup file to prevent excessive backup and insufficient disk space.

5. Check the space occupied by each table in the DB and dB, and monitor whether there are exceptions, such as sudden increase in the size of a table. The report function is convenient and intuitive.

6. Check whether the SQL Server Agent is normal and whether the job is executed normally. It is important because jobs usually clean up data or summarize reports.

7. Every week, you need to use the profile to capture the SQL statements executed for 15 minutes and put them into the table to optimize SQL statements for time-consuming, io-consuming, CPU-consuming, and other operations.

8. Check whether the growth mode of data files and log files is reasonable and whether the maximum growth value is set. We recommend that you increase the variable by 300 M. We recommend that you do not use the percentage.

9. Check the error logs to check whether an error has occurred. The record is comprehensive. It is also a good choice for troubleshooting.

10. Regularly contract the database, update statistics, contract the database, and reorganize the index

Adding .............