Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Where is memory for the user log cache allocated from?

April 26, 2017allocated cache log memory user

0

Posted

Where is memory for the user log cache allocated from?

1 Answer

0

Posted

Memory for the user log cache and for other new 11.0.x features comes from total memory at startup time; consequently, you will see less memory remaining in the data cache after upgrading to 11.0.x unless you readjust your memory configuration. When you upgrade from 10.x (or 4.9.x) to 11.0.x, the server will allocate user connections * 2048 bytes (1 page) for the user log cache at start-up time. So, for example, if you configured 1000 user connections before upgrade, 1000 pages will be taken away from your other caches at upgrade time and allocated for user log cache. Review this and other memory issues before upgrading; for more information, see the SQL Server Migration Guide: Moving from Release 10.x or 4.x to Release 11.x.