-
Titre
Enabling the Lock Pages in Memory Option (Windows). -
Description
Is it ok to enable the Lock Pages in Memory (LPIM) option for the Archive Manager service account? -
Cause
Clarification on support for this option. -
Résolution
Technically, there is no issue in enabling the Lock Pages in Memory (LPIM) option for Archive Manager service account. However, it has been suggested that should the SQL Server be dedicated for Archive Manager usage only, the benefits would be minimal (if any).
While this option may improve the performance, administrator(s) should be mindful of the physical memory available. If the physical memory is insufficient, enabling the option may in fact give rise to potential memory issues when the system is prevented from paging the data to virtual memory on disk.
Hence, our recommendation is that an administrator should only consider enabling this option if he/she is confident that there is sufficient physical memory on idle.
In addition, the following best practices are recommended:
- Ensure proper documentation of the change(s) made for rollback (if needed).
- Database performance is to be monitored over a period.
Disclaimer: Since SQL Server is a separate product entity offered by a 3rd party vendor (Microsoft), Quest Support is unable to offer any troubleshooting assistance over this change. In the event of potential issue(s) after committing this change, it is suggested to undo the change(s), and the software vendor should be contacted if further assistance is needed.
-
Informations supplémentaires