I read within IMDB docs that temporary databases will highly benefit of this feature.
I tested this with user temporary db and it worked with substantial improvements.
But I could not manage to put dml_logging minimal on standard tempdb database , with or without 'dbo use only' , with another sarole bound to another tempdb . Everytime I get 'database in use' and I cannot apply this option. I tried with putting model db with this option and restart , without success.
Is anyone who tried this and succeeded ?
I think I will ask support.