?
Solved

SQL 2000 Evaluation Download

Posted on 2009-02-12
8
Medium Priority
?
3,861 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.
0
Comment
Question by:j4piper
  • 4
  • 4
8 Comments
 
LVL 1

Expert Comment

by:FiveForFighting
ID: 23628953
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.
0
 

Author Comment

by:j4piper
ID: 23629004
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.
0
 
LVL 1

Expert Comment

by:FiveForFighting
ID: 23629088
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
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 

Author Comment

by:j4piper
ID: 23629110
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?
0
 
LVL 1

Expert Comment

by:FiveForFighting
ID: 23629393
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.
0
 

Author Comment

by:j4piper
ID: 23632236
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
0
 
LVL 1

Accepted Solution

by:
FiveForFighting earned 2000 total points
ID: 23632409
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?
0
 

Author Comment

by:j4piper
ID: 23632528
You are good!  Thank you for the directions.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

839 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