sql server express 2008 limitations

Posted on 2009-04-02
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
Question by:ThomBowman
  • 2
  • 2
  • 2
LVL 12

Accepted Solution

udayakumarlm earned 250 total points
ID: 24047991
SQL2008 express edition will use only one CPU. for limitations of express edition check
LVL 22

Assisted Solution

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.

Author Comment

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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

LVL 22

Expert Comment

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.
LVL 12

Expert Comment

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.

Author Comment

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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS SQL combine two tables by splitting codes in one table into multiple values 6 33
Add '#' to end of file 2 30
T-SQL: Nested CASE Statements 4 24
Sql query 107 27
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

920 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

13 Experts available now in Live!

Get 1:1 Help Now