I would like some assistance with recommended Memory and Processor settings for the attached screens.
The goal is to maximize the performance of SQL Server to give application users the fastest response to query and processes.
About the environment:
Windows 2008 Server Standard
MS SQL 2008 Server
on a VM dedicated to only running SQL Server
Running on a VM with the folliwing specifications:
All SSD VMWARE Data Store
VM Memory set at 32GB
VM Processor set at 4 processors x 6 Cores = 24 Total Processor Cores
Your input as to any changes to the settings in the two included screenshots would be greatly appreciated.