Hi,
I’m hoping someone will be able to help. With the help of the product developer and a contractor we have developed a version of our software to run on SQL Server Express rather than a desktop database. Neither the contractor or developer are great hardware experts.
I am looking at the Database Server as I have already decided that it will require a dedicated machine. My question is firstly – Server technology or just High end desktop with lots of ram, multicore processor and some SCSI or SAS drives.
Then secondly, operating system: again Server technology or XP Pro with the connections limitation removed ?
The application is likely to have up to 10 concurrent users per database, and obviously is more high volume low data size rather than a large infrequently queried one.
Any suggestions gratefully received!
Thanks
Matthew