Solved

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

Posted on 2008-06-26
4
185 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
View SQL 2005 Job package 16 77
MS Endpoint Protection 2 72
Find results from sql within a time span 11 55
How to rollback Windows updates with SCCM? 6 82
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…
Learn about cloud computing and its benefits for small business owners.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

749 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