Solved

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

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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

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…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

632 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