What is the optimal hardware configuration for maximizing the performance of an Access Database?
I need to buy a server and I'm looking at getting a 4 core Xeon running at 3.4 GHz but I'm also seeing other processor options for 6 to 8 cores or higher (10+) cores. I know that the Cache size is a factor and the memory speed is a factor but I really don't know exactly what to optimize? The higher cores don't have as high a clock speed - the highest clock speed is 2.8 or 2.5 GHz.
I don't know which elements truly matter to maximize the database performance.
I'm planning to use an SSD drive - Samsung Evo Pro 1 TB - and I'm planning to use Windows Server 2012 R2.
I am open to any and all suggestions.