Solved

sql server express 2008 limitations

Posted on 2009-04-02
6
494 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
  • 2
  • 2
  • 2
6 Comments
 
LVL 12

Accepted Solution

by:
udayakumarlm earned 250 total points
Comment Utility
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
Comment Utility
"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
Comment Utility
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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 22

Expert Comment

by:dportas
Comment Utility
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:udayakumarlm
Comment Utility
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
Comment Utility
both of you have answered my question and advised me on the way forward
Thanks guys
Tom
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Need Counts 11 39
SQL Query Syntax Error 9 29
t-sql splitting string column 5 24
Azure SQL DB? 3 11
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now