Easy to master the way of database management--operation and maintenance Patrol II (database)

Objective

To do daily inspection is an important step of database management and maintenance, and it is necessary to register each inspection date and result, and may need to make a inspection report.

This series is designed to address some common problems:

• I don't know what to patrol.
• Don't know how to get a quick checkup
• Machine Too much physical examination trouble
• Difficult to generate reports, no visual rendering of results

After hardware inspection, the inspection of the status of the database is undoubtedly the second step of daily operation and maintenance patrol. The inspection of the database mainly includes the file size, configuration information, space allocation and other objects.

Database size

1. In the SQL Expert Cloud "Overview" page can be graphically view the database file size, as an operator we first need to know how large the operation of the database? How big is the data file? How big is the log file?

Note: In comparison with the previous collection, you can learn about the increment of the database over the two collection time period.

Note: If the log file is too large, it is in full backup mode, and the log backup is missing or the backup frequency is unreasonable.

　　

2. database file size and detailed information in the SQL Expert Cloud Database-Overview page.

Note: It is also possible to know the number of tables, views, functions, and stored procedures in the system, as compared to the previous collection, how many new objects have been made by the developer or maintainer during this period.

　　

Database configuration

1. Review the configuration information for each database in "check"-"all" and the platform will prompt for a warning when the database configuration does not pass a regular check.

Note: Improper configuration of all databases may cause problems such as performance or security. Each patrol needs to be aware that some of the affected configurations have been accidentally opened, or have not been optimally configured in the early stages. (Database configuration recommendations are described in the best configuration in the platform)

　　

2. In the database-configuration page, view the configuration information for the database, which contains the database size, recovery model, compatibility level, collation, time of the last checkdb, and so on.

　　

File information

View information such as file allocation, file size, growth configuration, path, and so on in the database-Files page.

　　

Space allocation

On the database-space page, you can view information such as the number of rows in a Table object in the database and the allocation space.

Note: The system administrator or OPS personnel should pay attention to the large table in the system, through the change of large table row number and occupy space, give advice and plan, such as whether to do partition table, whether to archive historical data, etc.

　　

Summarize

To the database file allocation, file size inspection, you can see the magnitude of the data and daily growth, only to understand these can make managers in the decision-making more evidence.

Database configuration has a great impact on performance, security and so on, when the database configuration is inadvertently modified without notice, when problems occur, it may be difficult to troubleshoot.

For the big table in the system, each administrator should raise the concern, the increment of big table, the design of big table is reasonable, etc., have great influence on the stability and performance of the system.

Easy to master the way of database management--operation and maintenance Patrol II (database)