This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to improve DB performance? Can we add index on DB?

Hi,

We have 55k users in One IM for which we are trying to provision AD accounts for these users. We have increased DB capacity to 16CPU/64GB and enabled the trace flag as well. And the staging level of DB is set to "Production". Still, the performance is not that good. Can we add index on DB tables so as to improve retrieval of data from DB? Else what is the recommended way of improving DB performance now?