Solved

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

Posted on 2008-10-09
5
155 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
  • 2
  • 2
5 Comments
 
LVL 60

Accepted Solution

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

Assisted Solution

by:Cedric_D
Cedric_D earned 250 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

758 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

20 Experts available now in Live!

Get 1:1 Help Now