Solved

which version of sql server 2005 for a single cpu Windows 2003 server

Posted on 2008-06-26
4
182 Views
Last Modified: 2010-04-18
I will have multiple domains on a Windows 2003 Standard system with 1 cpu.

Which version of Sql Server 2005 should i use?  And this will be an upgrade from Sql Server 2000.

0
Comment
Question by:bobsocks
  • 2
  • 2
4 Comments
 
LVL 11

Expert Comment

by:jfields71
ID: 21875487
That depends on what you want or need to do with it.  It appears as if you could actually use the free Express version.  However, it has many limitations.  How much RAM you have and if you need features such as clustering would determine which edition to get.  We ended up buying Standard Edition for our severs.  I used this chart here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
0
 

Author Comment

by:bobsocks
ID: 21875852
I looked at that chart.  My guess was workgroup or standard.

Problem with express is the 1 gig limit on memory.  The system has 4 gig.  There will be no clustering.
0
 
LVL 11

Accepted Solution

by:
jfields71 earned 50 total points
ID: 21875879
Then I would go with Standard.  It removes some of the arbitrary limitations of Workgroup edition (RAM) and gives you some upgrade options.  Should you add more RAM to the system, add more CPUs, or upgrade to a 64-bit OS, Standard will give you better performance.  Basically, it gives you more room to grow if you ever need more than what you have today.
0
 

Author Comment

by:bobsocks
ID: 21877355
Now where do I find info on an upgrade from 2000 to 2005?  Specifically, the best price.
0

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

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
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.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

911 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