We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

SQL 2000 Evaluation Download

Medium Priority
3,969 Views
Last Modified: 2012-05-06
Back in September I downloaded this 120 day copy to my Dell Multi-CPU Server.

Working great but will soon run out on the license trial period.

I want to upgrade this version to SQL 2005 Enterprise with 25 licenses.

My question is the following; Is MS SQL 2000 Trail Copy a wide-open version that utilizes all the processors in my server (Server has 8 Xeon CPUs), therefore giving me full performance?

My next question is; If I am expecting at least the same performance as SQL 2000 on my server and upgrade to SQL 2005, what license model do I need to purchase?  Standard? Enterprise?  I am needing at least 25 licenses for my users. I don't know how to spec out the Processor license?  

I want the most performance that I am seeing now with my SQL 2000 Trail Copy --- Not sure how that compares to the SQL 2005 Model?

Very confused from Microsoft purchasing model....once again.
Comment
Watch Question

Here is a feature comparison of the SQL 2005 Editions for reference - It isn't a direct answer to your two questions but should shed some light on the feature differences (software/hardware) between the version you are using now and where you want to go.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx?PHPSESSID=0324345d45ef1bf1f764044e03584cd0

Also - note that SQL2008 is already out and you may want to go with that over SQL2005.

Up to this point all my installs use per CPU licensed Standard Edition... that list prices for around $4K per processor.  I think that Enterprise Edition Per Processer is over 20K.  

That being said - if you only need 25 clients - then you may want to look at Client Access Licensing (CALS) - regardless of the version you go with since the break even between CALS / Per Processor (on standard) was around 80 users or so.

I would advise getting in touch with someone at MS and discussing your performance needs and licensing options with them.

Author

Commented:
That is a good chart.  Thank you.

I guess I don't understand the 1-Processor Enterprise Edition versus the Enterprise Edition version?

I have searched MS website all over and have not found a number to call them.  Ideas?

Thanks.
The Enterprise Edition is just the Enterprise Edition.  How many processors you want to use = how expensive it is going to be.  My servers run standard w/ two Processors.  I had to buy two processor licenses per server to run them.  As you can see - with Enterprise Edition it can start to get expensive - not that it isn't worth it in many cases.

Some pricing info - http://www.microsoft.com/sqlserver/2005/en/us/pricing.aspx

Some major resellers that should be able to answer specific licensing questions and/or put you directly in touch w/ a MS rep in your business area. - http://www.microsoft.com/sqlserver/2005/en/us/large-account-resellers.aspx

Author

Commented:
Do you have any idea on SQL 2000 Eval from MS as to how many processors it used?

What I don't want to do is buy a copy of SQL 2005 EE and find out that it is slower than the SQL 2000 Eval copy then have to scramble and buy more speed.

Thoughts?
In the Enterprise Manager you can right click on the connection - look at the properties - and see how many processors are being used by SQL Server.

Author

Commented:
Shows to be running all 8 processors.  Does this mean that I am going to be spending a Billion dollars on a SQL 2005 license to be equivalent to the SQL 2000 version?

One new question: I just downloaded an eval version of SQL 2005 EE.  To upgrade my current SQL 2000, is it a matter of running the install and it will know that it's an upgrade, making the upgrade smooth?

Joe
Run the SQL Server upgrade advisor before you try anything else... http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en

I have a feeling, though I have never tried it, that installing an eval on top of an eval may not work well.  

You may want to ask yourself - Other than using 8 processors instead of 4 - what features of the Enterprise Edition do I need that the Standard Edition doesn't have?  You can refer back to the link in my first response to review the feature matrix.  Also - though you are currently "using" 8 processors - have you looked at any of the performance counters on the system to see if you really are using more than a few percent of each processor?

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
You are good!  Thank you for the directions.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.