Can we make certain tables memory optimized in the MDB. Our SQL team has recommended making usp_record_lock as "memory optimized" table which is a feature in SQL 2014. Do you have any concerns or recommendations on doing this ?
This is not something that we tested and not sure how the MDB updates would be affected. This would not be a supported modification.