Discover our Clipsal Smart Home packages as seen on the Block

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    What does lock pages in memory do as stated on the Setting SQL Server memory options in our PME 8.x installation manual?

    Issue
    The PME 8.x installation manual states to consult the site administrator to determine where or not to enable the Lock pages in memory permission setting in Windows for The SQL service account on all SQL server instances. What exactly does this setting do? Product Line
    PME 8.x.

    Environment
    PME 8.x, Microsoft Windows, SQL Server

    Cause
    This note from the installation manual is not clear of what the permission setting does.
    In addition to setting the maximum memory option, consult with your site administrator to
    determine whether or not to enable the Lock pages in memory permission setting in
    Windows for the SQL service account on all SQL Server instances.


    Resolution
    Lock Pages in Memory 
    This Windows policy determines which accounts can use a process to keep data in physical memory, preventing the system from paging the data to virtual memory on disk. Locking pages in memory may keep the server responsive when paging memory to disk occurs. The SQL Server Lock Pages in Memory option is set to ON in instances of SQL Server 2016 Standard edition and higher when the account with privileges to run sqlservr.exe has been granted the Windows "Locked Pages in Memory" (LPIM) user right.

    Virtual memory systems allow the over-commitment of physical memory, so that the ratio of virtual-to-physical memory can exceed 1:1. As a result, larger programs can run on computers with a variety of physical memory configurations. However, using significantly more virtual memory than the combined average working sets of all the processes can cause poor performance.




     

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance