We have engaged extensively with Microsoft over the last few months in an effort to understand and conquer some of the substantial performance issues we have been experiencing.

One of the things to come out of our journey is that the DAMS utility that sits behind D365 carrying out automated maintenance tasks (new indexes, optimising indexes / query plans) is extremely opaque.

It would be very helpful if:

1. Output of its activity (both successful and unsuccessful) was available for inspection
2. The parameters that are integral to DAMS routines kicking off were made available so we could have better understanding of the process.
3. The parameters are not blanket set across an environment. There should be flexibility to change these values per table / index. Even if this action is not available to the end user, it should be readily accessible by a mechanism such as logging a support ticket.