I'm looking at buying a new software package for our company and I need to spec a suitable server for it.
The software uses MS SQL server to store the data. They haven't (so far) been able to provide me with info I can use to size suitable server hardware.
The company say it can run on SQL express or the bigger versions. I see that the non-express versions of SQL can use multiple CPU sockets and more than 1GB RAM.
Does the product/database have to be developed in such as way as to take advantage of the extra hardware? Or does SQL server automatically do this for you? (and therefore give you much better performance?)
If it's relevant; the software's data is not all in one big database, but is split into one database per client (of ours).