SQL Server - VMWare install - Utilize more RAM
- by alex
We have a SQL server machine - It’s a VMWare image (running on ESXi hardware etc..)
It has windows 2008 x64 standard
The SQL install is SQL 2008 standard
The virtual machine has 12gb of RAM, and 4 virtual CPU
The box is suffering from near 100% CPU a lot of the time
I enabled the AWE- but SQL server only seems to use 3-4gb of RAM
Is there a way of making it use more available ram more effectively?
cache results for example..?