One client experienced performance issues after enabling Lock pages in memory. The problem arose due to a misconfigured Windows page file. The page file was either not configured at all and "automatically manage paging file size for all drives." was unchecked. This caused SQL Server performance to degrade significantly, and errors such as "Failed allocate pages: FAIL_PAGE_ALLOCATION 3593" were logged.
Solution:
After configuring the Windows page file properly, the issue has been resolved.
Comments
Post a Comment