2008 R2

awe to allocate memory(AWE)
allow 32-bit operating systems to access large amounts of memory.
* This feature will be removed in the next version of Microsoft SQL Server.

# SQL Server runs at a priority base of 13, default 7
scheduling priority than other processes on the same computer

Boost SQL Server priority

要 Stop and restart SQL Server

* This feature will be removed in a future version of Microsoft SQL Server.

use windows fibers lightweight pooling

The overhead involved in switching thread contexts is not very large.
Most instances of SQL Server will not see any performance differences between setting the lightweight pooling option to 0 or 1.
The only instances of SQL Server that might benefit from lightweight pooling are those that run on a computer having the following characteristics:

- A large multi-CPU server.
- All the CPUs are running near maximum capacity.
- There is a high level of context switching.

# We do not recommend that you use fiber mode scheduling for routine operation.
* some components of SQL Server cannot function correctly in fiber mode.

Common language runtime (CLR) execution is not supported under lightweight pooling.