Filter
Top Products
Parameter Value Notes
®
Page_verify_option Checksum (Microsoft SQL Server
default)
READ_COMMITTED_
SNAPSHOT
On
Microsoft SQL Server Memory with Address Windowing
Extensions (AWE)
You can use the Microsoft SQL Server memory (with AWE) when running
Microsoft SQL Server (32 bit) on Windows Server (32 bit).
This is helpful when your server has more than 4 GB of RAM and you want
Microsoft SQL Server to be able to use that. For using Microsoft SQL Server with
AWE, use the recommended values for Min and Max server memory for instance
level settings.
For more information on Enabling AWE Memory for Microsoft SQL Server
Memory, refer to the Microsoft Developer Network Web site:
v http://msdn.microsoft.com/en-us/library/ms190673(SQL.90).aspx (Microsoft
SQL Server 2005)
v https://technet.microsoft.com/en-us/library/ms190673%28v=sql.105%29.aspx
(Microsoft SQL Server 2008)
This feature was removed in Microsoft SQL Server 2012. For more information, see
https://support.microsoft.com/en-us/kb/2663912.
Row Versioning-Based Isolation Level
(READ_COMMITTED_SNAPSHOT) for Microsoft SQL Server
This feature is available in Microsoft SQL Server 2005 and later versions,
This feature can help in the following ways:
v Resolve concurrency issues such as excessive blocking
v Reduce deadlocks
The following T-SQL statement enables the READ_COMMITTED_SNAPSHOT for
a database:
ALTER DATABASE <DB NAME> SET READ_COMMITTED_SNAPSHOT ON;
This snapshot option increases the number of I/Os as well as the size of tempdb. It
is important to have tempdb on fast disks as well as to have it sized according to
your workload.
For more information about Using and Understanding Snapshot Isolation and Row
Versioning, refer to the Microsoft Developer Network Web site, which can be
accessed from: http://msdn.microsoft.com/en-us/library/tcbchxcb(VS.80).aspx.
Recommended Settings for Microsoft SQL Server 2008 and 2012
Recommended settings for Microsoft SQL Server 2008 and Microsoft SQL Server
2012 are provided.
These are shown in the following table:
Performance Management 53