Wednesday, March 21, 2012

Purchasing SQL

I've looked through a number of sites trying to find the difference between
the different "types" of SQL Server. We have a company that has
approximately 50 internal website users and approximately 2-3000 external
website users (no idea how many concurrent).
What type of SQL Server software will we need? My last company had SQL
2000 Enterprise, but they had a legitimate budget. This company is
searching on pricegrabber for Standard Edition 1 processor licenses and
trying to find the cheapest deal (you wouldn't believe this if you saw it).
Anyway, I'd like to provide some insight...as I know they're about to get
ripped off, but I figured I'd do some homework first. Any info would be
fantastic. Thanks.
James"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
One of the biggest drawbacks of standard vs. enterprise is the 2 gig memory
limit on standard. Of course, there are other features/benefits of
enterprise, but that is a deciding factor for a lot of people.
-John Oakes

> James
>|||How many SQL Server boxes are you going to have? You could have thousands
of websites pointing to one SQL Server if you wanted. Or you could have one
SQL Server box per web site.
You mention that "they're about to get ripped off." What does that mean?
Are "they" spending too much? Do "they" think that they need to purchase
one copy of SQL Server for every web server?
You are correct in searching for the Per Processor license, as this is what
you will need in order to use it to drive a web site (or sites).
The standard Edition of SQL Server is usually sufficient for most people.
Enterprise does have some additional high availability features (clustering)
and some other features that can improve performance (indexed views, greater
memory support), but those features come at a cost.
Only you can determine what features you require. These features will
determine what version of SQL Server to purchase.
Keith
"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
> James
>|||Thanks for the reply. We'll only have one SQL Server box. When I said
they're about to get ripped off...I meant that they're searching for the
software on sketchy sites with rather large discounts. Microsoft is selling
the processor license for $5000 if I'm reading this anywhere near right, and
they're looking at copies that are barely over $1000. It just doesn't seem
"kosher" to me. The 2 Gig limit...that refers to the amount of memory the
box itself can have? I don't know that this would be a problem or not.
I'll have to look into that.
Thanks,
James
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OGZW8nSXEHA.1000@.TK2MSFTNGP12.phx.gbl...
> How many SQL Server boxes are you going to have? You could have thousands
> of websites pointing to one SQL Server if you wanted. Or you could have
one
> SQL Server box per web site.
> You mention that "they're about to get ripped off." What does that mean?
> Are "they" spending too much? Do "they" think that they need to purchase
> one copy of SQL Server for every web server?
> You are correct in searching for the Per Processor license, as this is
what
> you will need in order to use it to drive a web site (or sites).
> The standard Edition of SQL Server is usually sufficient for most people.
> Enterprise does have some additional high availability features
(clustering)
> and some other features that can improve performance (indexed views,
greater
> memory support), but those features come at a cost.
> Only you can determine what features you require. These features will
> determine what version of SQL Server to purchase.
> --
> Keith
>
> "James Baker" <cppjames@.hotmail.com> wrote in message
> news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> between
external[vbcol=seagreen]
> it).
get[vbcol=seagreen]
>

No comments:

Post a Comment