Currently our client is running Microsoft SQL Server 2008 Express Edition and had hit the 4GB capped. We need to provide a solution to them and I notice there are two option(as topic) for them now.
The application will use the database intensively and there's an Time Management System running too. Data need to be inserted every 30 minutes and all the while there will be users using the ASP.Net application. Automated process is also running from time to time in the Web Service too.
And I notice the "Number of CPU" limitation in SQL Server, does it mean "1 CPU" equal to "1 Physical Processor"? or does it mean "1 Core in 1 Physical Processor"? or "multi-core in 1 Physical Processor"?
So can anyone give me more details and advises?