?
Solved

Which edition of MS SQL 2008 is sufficient for my needs?

Posted on 2008-10-09
5
Medium Priority
?
197 Views
Last Modified: 2012-05-05
I have built a new server with 4GB ram, 2 Xeon E5410 cpu's on a Tyan Tempest I5400XT motherboard with 4 500gb harddrives set in a 0+1 raid format.
Access 2007 database in a solo physician clinic with no more than 10 concurrent users.

I want to take advantage of the two cpu's.

Can the express edition work for me or will I need the workgroup edition?
0
Comment
Question by:reikolayman
[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
5 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 1000 total points
ID: 22682251
I beleive WorkGroup edition will meet your needs.
0
 
LVL 7

Assisted Solution

by:Cedric_D
Cedric_D earned 1000 total points
ID: 22682385
0
 

Author Comment

by:reikolayman
ID: 22682494
I thought the workgroup edition would work, but I was confused by the # processors, as the Xeon is a quad core.  I think by 2 they mean two separate processors and in that event it would take advantage of both cpus.  I also noticed that the express is limited in ram and the workgroup (32 bit) was not limited.

Too bad free sure is cheap!
0
 

Author Comment

by:reikolayman
ID: 22682556
Also if I have 7 users and 1 network printer will I need to purchase 7 or 8 cal?
0
 
LVL 7

Expert Comment

by:Cedric_D
ID: 22776913
When you buy SQL product, usually it already contains 5 or 10 CALs, this stated in the price.
There's no CAL necessary for printer, I think.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

752 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