Database maintenance best practices

Hi,

Are there any documents except the database maintenance tool described in the Aveva MES documentation?
docs:docs.aveva.com/.../79682.html

It works for purge and archiving of the mesdb but it isn't for maintaining the database to keep it performing as it should be.
It should include any rebuilding/reorganizing of db indexes.
I understand this should be handled at a Microsoft level but are there documents, technotes or best practices someone can share with me please?

Kind Regards

Parents
  • In addition to the technote mentioned by Ed, the MES Deployment Guide also has recommendations on what to monitor and related concepts.  As SQL Server is a Microsoft product, AVEVA doesn't provide in depth details of how to setup rebuilding or reorganizing indexing or how to setup backups.  Those details are provided by Microsoft for the version of SQL Server you are using.

    Deployment Guide link to Production Database Server key parameters:

    Key Parameters

Reply
  • In addition to the technote mentioned by Ed, the MES Deployment Guide also has recommendations on what to monitor and related concepts.  As SQL Server is a Microsoft product, AVEVA doesn't provide in depth details of how to setup rebuilding or reorganizing indexing or how to setup backups.  Those details are provided by Microsoft for the version of SQL Server you are using.

    Deployment Guide link to Production Database Server key parameters:

    Key Parameters

Children
No Data