database...do we need to buy two licenses of SQL enterprise. It will reside
on an active\passive cluster. Can I use SQL standard?
Dan
You can use a single SQL Server 2005 Std license or a single SQL Server 2000
Enterprise license.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"DEAKER00" <deaker00@.hotmail.com> wrote in message
news:dmTcf.18409$1L3.845653@.news20.bellglobal.com. ..
> Looking for quick answer. If we implement a 2 node cluster fora single SQL
> database...do we need to buy two licenses of SQL enterprise. It will
> reside on an active\passive cluster. Can I use SQL standard?
> Dan
>
|||Per CPU, yes?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OpkMY4m5FHA.2192@.TK2MSFTNGP14.phx.gbl...
> You can use a single SQL Server 2005 Std license or a single SQL Server
> 2000 Enterprise license.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> "DEAKER00" <deaker00@.hotmail.com> wrote in message
> news:dmTcf.18409$1L3.845653@.news20.bellglobal.com. ..
>
|||It doesn't matter
http://www.microsoft.com/sql/howtobu...vepassive.mspx
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23pYrecs5FHA.252@.TK2MSFTNGP15.phx.gbl...
> Per CPU, yes?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:OpkMY4m5FHA.2192@.TK2MSFTNGP14.phx.gbl...
>
|||I know the passive box doesn't need licenses, but if the active node has
more than one CPU socket exposed to the O/S, and therefore to SQL as
well...don't you need a license for each one on the active node?
It's entirely possible I am mistaken :-)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:%232BtL3w5FHA.4076@.tk2msftngp13.phx.gbl...
> It doesn't matter
> http://www.microsoft.com/sql/howtobu...vepassive.mspx
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:%23pYrecs5FHA.252@.TK2MSFTNGP15.phx.gbl...
>
|||"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in
news:eStEXeS6FHA.2176@.TK2MSFTNGP14.phx.gbl:
> I know the passive box doesn't need licenses, but if the active node has
> more than one CPU socket exposed to the O/S, and therefore to SQL as
> well...don't you need a license for each one on the active node?
> It's entirely possible I am mistaken :-)
You're not completely mistaken. You are required to have licences for the
number of physical CPUs on which Sql Server 2005 is configured to run, by
deafalt that is all available CPUs (afaik). However, if this number is
different on the two nodes, you'll need licenses for the higher number. If
the SQL Server is configured with multiple instances, and by configuration
can run in Active/Active mode then you'll need licenses for both servers.
If you think this is difficult, look on the licensing rules for Oracle
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
|||Also keep in mind that there are different ways to classify a CPU: socket,
physical, and logical. Microsoft has amended their physical/logical
licensing to now focus on the socket.
This means that when the Intel Itanium2 Montecito chips are available, they
will be multi-core (dual to start with) and hyper-threaded. So, you could
have a 4-way socket installation but expose what would appear to be 16
logical CPUs to the OS and SQL Server, but Microsoft would only require you
to license the 4 sockets per-processor license. Moreover, those bad boys
are IA64.
Now, that's a bargain. Can you imagine the muscle something like the HP
Superdome will have rolling out a 16-way installation with these chips?
With a single Superdome, you could load it with 32 of these processors,
create 2 LPARs, install a 2-node cluster, multi-instanced, each with 16
sockets, but each looking like it has 64 logical CPUs? Wow!
For those not so lofty at heart, there is also the Paxville x64 Xeon variant
that is also supposed to be released as dual-core and hyperthreaded.
Either way, x86, x64, IA64, a CPU is a CPU and if Microsoft is only going to
charge you per-socket, get the most bang for your buck.
Sincerely,
Anthony Thomas
"Ole Kristian Bangs" <olekristian.bangas@.masterminds.no> wrote in message
news:Xns970EA5F525F62olekristianbangaas@.207.46.248 .16...
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in
> news:eStEXeS6FHA.2176@.TK2MSFTNGP14.phx.gbl:
>
> You're not completely mistaken. You are required to have licences for the
> number of physical CPUs on which Sql Server 2005 is configured to run, by
> deafalt that is all available CPUs (afaik). However, if this number is
> different on the two nodes, you'll need licenses for the higher number. If
> the SQL Server is configured with multiple instances, and by configuration
> can run in Active/Active mode then you'll need licenses for both servers.
> If you think this is difficult, look on the licensing rules for Oracle
> --
> Ole Kristian Bangs
> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
No comments:
Post a Comment