AnsweredAssumed Answered

Database maintenance - mdb database

Question asked by ipsku01 Employee on Dec 7, 2017
Latest reply on Dec 15, 2017 by jmayer

Hello out there,

what do you or your customers do for mdb database maintenance. I'm especially interested in maintenance of Indexes.

How do they maintain indexes, how often, with or without shutting down SDM etc.


The reason I'm asking is that I have customer where we experience database locks every now and then caused by Index maintenance. It happens every 4 - 8 weeks where a query operation from SDM locks with the ALTER INDEX operation from the maintenance job. It is now about to reach escalation point - so any insight from you guys out there would be very appreciated.