Standard or Enterprise?

[kensington43]

I want to purchase SQL Server 2003 to locate on my IIS Web Server with Windows 2000.

Please advise the difference between Standard edition and the Enterprise edition?

I want to build many databases in the next couple years using SQL Server 2003 as a backend to my Cold Fusion and JSP Front end.

 

[SQLDenis]

I assume you mean SQL server 2005
If so then take a look here

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[kensington43]

Thanks for quick response.
I thought SQL Server 2003 was latest edition.

What is meant by the "Number of CPUs"?

 

[SQLDenis]

Number of processors (CPU = Central Processing Unit)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[kensington43]

Thanks,

If I choose Standard I have to make sure the Web Server only has 4 or less CPU's connected to it?

 

[mrdenny]

Correct, Standard edition of SQL 2005 supports up to 4 processors.

You will see better performance if you put the SQL Server on a seperate server than your web server. You can then put the SQL 2005 server on a Windows 2003 server and keep the IIS server windows 2000.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[kensington43]

Thanks,

I have never worked with SQL Server 2005. I assume if I buy the Standard edition and was forced to put it on the Web server due to money issues then I can create several databases in it?

I can then create many schemas in the SQL Server 2005 but each schema would be seperated from the other ones?

I have only used Access 2000 in the past and each time I created a Web backend database I had to create a new Access 2000 database on the server. I assume SQL Server works different where I have many databases stored in the SQL Server??

 

[mrdenny]

Correct you can place many SQL databases within a single SQL Server instance. With SQL 2005 you can have more than one schema within each database.

I'm assuming that you will be putting Windows 2000 Standard Edition on the server. With Windows 2000 standard there is pretty much no reason to use SQL 2005 Enterprise.

Keep in mind that your licensing costs will go up as you add more CPUs to the server. For standard edition your licensing costs come in at $5,999 per processor for the SQL Server. If you have a quad chip server that's $23,996 for the SQL Server.

If cost is going to be a issue you may want to look at the lower end versions of SQL Server 2005. Workgroup edition is more scalled down version that Standard edition, but it only costs $3,899 per CPU. There is also the Express edition of SQL 2005 which is very scalled down, but it also free to use.

Use the link that SQLDenis posted and figure out which features you really need before deciding on the version of the software that you are going to use. Keep in mind that the Express edition doesn't come with the same user interface that the other editions come with.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com