Database Reference
In-Depth Information
Figure 11.65 Enabling the Perform volume maintenance tasks setting.
Note
More information on the Instant File Initialization setting, refer to
http://msdn.microsoft.com/en-us/library/ms175935.aspx .
Repeat the enabling of AlwaysOn Availability Groups, Large Pages (if necessary),
Lock Pages in Memory, and Perform Volume Maintenance steps on all SQL Servers
participating in the AlwaysOn Availability Group.
Configuring the Min/Max Setting for SQL Server
As was discussed in Chapter 7 , we are going to create a SQL Memory buffer pool,
ensuring that the OS and non-SQL applications (backup programs, antivirus, and so on)
have enough resources to run as expected. To do this, open Microsoft SQL Server
Management Studio and right-click SERVER NAME and select Properties . On the
Server Properties - <Server Name> page, click Memory . For purposes of our
configuration, we left Minimum server memory (in MB) at the default setting of 0 and
we configured Maximum server memory (in MB) at the default setting of
2,147,483,647 MB to see how SQL Server handles dynamically managing memory; this
is shown in Figure 11.66 . We left the default settings in to see what SQL 2012 can do
“out of the box.” This provides us a baseline to measure against as well as adheres to
our “keep it simple” mantra. In additional testing, we would adjust these settings based
 
 
Search WWH ::




Custom Search