• Again, no. There's not enough information to make intelligent suggestions. You've listed an OS and version, SQL Server version, and the fact that you're running on a VM, but not even what kind of VM. VMWare or Hyper-V or something else? If it's VMWare, go to the VMWare site and search for SQL Server, they have suggestions on how best to configure the VM. If it's Hyper-V, same thing, but go to MSDN.

    As for the OS and SQL Server, without knowing the number and type of processors and the amount of memory, there's nothing you should do or change, let the default install do all the work. With better information, suggestions could be made, but there's nothing magic that I have that lets me know what's going on at your site so I can tell you what to do.

    "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