Maintenance DB in production

Ignition
1

Hi,
What are some key good practices for DB maintenance, such as:

  • Important metrics in the DB to monitor during production?
  • What type of scripts we can run on the DB for maintenance?
  • Partitioning DB?
  • etc
    Thanks