How often do "dirty pages" from ESE cache get written to transaction logs? What is the mechanism that triggers it? I was curious based on the fact that since RAM is utilized to reduce IO, at what point will these pages be written, I assume its got to be fairly dynamic and fluid as to reduce any form of data loss probability but I have yet to find specific information on it.
Thanks for lookin!
Cory
Thanks for lookin!
Cory