sql server express 2008 limitations

Hi there can you help, I plan to install a piece of software that requires SQL Server Express, the server I will be using will have 2 x XEON Dual core CPU's, I've seen that the express version is not supported for dual core cpu's and I may have to purchase the full SQL Server is this correct? There are only going to be 4 users using this software therefore I'm a bit reluctant to purchase software that is too much for what I need it for.
Can you help
Tom
ThomBowmanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
udaya kumar laligondlaConnect With a Mentor Technical LeadCommented:
SQL2008 express edition will use only one CPU. for limitations of express edition check
http://www.devx.com/MicrosoftISV/Article/38728
0
 
dportasConnect With a Mentor Commented:
"I've seen that the express version is not supported for dual core cpu's"
That's incorrect. SQL Server Express may be run on a PC with any number of processors or cores. An Express instance can only utilise one processor but it can take advantage of multiple cores on that processor.
0
 
ThomBowmanAuthor Commented:
thanks guys, the whole point of using the server with 2 dual cores is for the database, seems a bit pointless using a server with 2 processors if they are not going to be utilised, also it will only use 1Gb Ram, and I will have 4 installed.
Looks like I'll need to purchase SQL Server
0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
dportasCommented:
For only 4 users you may well get by with 1GB and 2 cores. Depends on requirements of course. OK for many OLTP -type applications, probably not OK for decision support.
0
 
udaya kumar laligondlaTechnical LeadCommented:
you can start with SQL2008 express server and see if it caters the need. if after some time your server starts to show some slowness then you can shift to SQL2008.

one dirty way is to install multiple instances of SQL server and load different databases on different instances. if you install two instances you can take advantage of the system resources.
0
 
ThomBowmanAuthor Commented:
both of you have answered my question and advised me on the way forward
Thanks guys
Tom
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.