• Just make sure you set the maximum memory size within the SQL Server instance and then, as stated, let SQL Server do the memory management for you. For your memory setting, assuming only SQL Server is running on the VM, I'd suggest leaving 4gb for the OS and giving the rest to SQL Server. You can read more about that here[/url].

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning