Solved

sql server express 2008 limitations

Posted on 2009-04-02
6
506 Views
Last Modified: 2012-05-06
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
0
Comment
Question by:ThomBowman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 12

Accepted Solution

by:
udaya kumar laligondla earned 250 total points
ID: 24047991
SQL2008 express edition will use only one CPU. for limitations of express edition check
http://www.devx.com/MicrosoftISV/Article/38728
0
 
LVL 22

Assisted Solution

by:dportas
dportas earned 250 total points
ID: 24048041
"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
 

Author Comment

by:ThomBowman
ID: 24048067
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 22

Expert Comment

by:dportas
ID: 24048088
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
 
LVL 12

Expert Comment

by:udaya kumar laligondla
ID: 24048113
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
 

Author Comment

by:ThomBowman
ID: 24048150
both of you have answered my question and advised me on the way forward
Thanks guys
Tom
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question