Does anyone have any guidance on what settings should be implemented in SQL 2008 R2 Full to run a SIMS Database? I have a server ready with Server 2008 R2 and 16GB RAM and I just need to install SQL. Are there any tweaks I should be doing to enable it to use both Processors (2 quad cores) and as much RAM as it needs? I have bought 2 x Processor licence so am covered for 2 processors.
Any pointers would be greatly appreciated.