Database - Good practices
This section presents topics related to good practices regarding database administration and maintenance. Make sure to check each one of these items.
â–ª Check the possibility of creating a routine to update statistics and defragment database objects.
â–ª Maintain a database backup routine; the frequency must be defined to meet technical and business requirements.
â–ª When possible, try simulating the need to restore backups; this measure aims to identify possible failures in their media and routine.
â–ª Periodically monitor the free space of the disk in which the database files are located; this way, it will be possible to prevent any type of failure due to lack of disk space.