Database Reference
In-Depth Information
Figure 11.63
Enabling Large Pages in SQL Server.
Note
Microsoft does not recommend using this Large Pages trace flag when
using the Column Store Index feature, per
Note
For more information on this and other trace flags available for SQL
Server, visit Microsoft's KB article on the topic:
Open the
Local Security Policy
management console. A quick way to do this is to open
PowerShell
and type
secpol.msc
. Once the console is open, locate and expand
Local
Policies
and then click
User Rights Assignment
. Under the Policy column, locate
Lock
pages in memory
. Right-click
Lock pages in memory
and select
Properties
. Add the
SQL Service account (svcSQL2012) and click
OK
to configure the setting.
Figure 11.64