Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesHello Everyone, Our company is currently under the Enterprise agreement with Microsoft and I was wondering when it came to clustering, how many processors do we have to licenses if both boxes has four processors in each box? The way we're running the cluster is Active/Passive. We are using SQL 2000 Standard edition along with Enterprise edition of Microsoft Windows 2003 Server. If someone could give me some insight I would highly appreciate it. Thank you Alex Anderson
Post Follow-up to this messageSQL Server 2000 Standard Edition doesn't support clustering, so that is your first problem. Now ignoring that, in an Active/Passive configuration you need only license the maximum number of processors on any server in that configuration. In your case that would mean 4. If you had a configuration where the usually active system had 4 and the usually passive system had 8 then you'd need to license 8. -- Hal Berenson, President PredictableIT, LLC http://www.predictableit.com "Alex Anderson" <AAnderson@Murrieta.org> wrote in message news:usdeZCoJGHA.668@TK2MSFTNGP11.phx.gbl... > Hello Everyone, > > Our company is currently under the Enterprise agreement with Microsoft > and I was wondering when it came to clustering, how many processors do we > have to licenses if both boxes has four processors in each box? The way > we're running the cluster is Active/Passive. We are using SQL 2000 > Standard edition along with Enterprise edition of Microsoft Windows 2003 > Server. If someone could give me some insight I would highly appreciate > it. > > Thank you > Alex Anderson > > >
Post Follow-up to this messageAlex Anderson wrote: > Hello Everyone, > > Our company is currently under the Enterprise agreement with Microsoft > and I was wondering when it came to clustering, how many processors do we > have to licenses if both boxes has four processors in each box? The way > we're running the cluster is Active/Passive. We are using SQL 2000 Standa rd > edition along with Enterprise edition of Microsoft Windows 2003 Server. I f > someone could give me some insight I would highly appreciate it. > > Thank you > Alex Anderson SQL Server 2000 Standard Edition doesn't support failover clustering. Your options are to upgrade to Enterprise Edition or to SQL Server 2005 Standard Edition, which do both support clustering. "Under each of these editions, keeping a passive server for failover purposes does not require a license as long as the passive server has the same or fewer processors than the active server (under the per processor scenario)." http://www.microsoft.com/sql/howtobuy/faq.mspx -- David Portas, SQL Server MVP Whenever possible please post enough code to reproduce your problem. Including CREATE TABLE and INSERT statements usually helps. State what version of SQL Server you are using and specify the content of any error messages. SQL Server Books Online: http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx --
Post Follow-up to this messageThank you both. Understood! Alex Anderson "Alex Anderson" <AAnderson@Murrieta.org> wrote in message news:usdeZCoJGHA.668@TK2MSFTNGP11.phx.gbl... > Hello Everyone, > > Our company is currently under the Enterprise agreement with Microsoft > and I was wondering when it came to clustering, how many processors do we > have to licenses if both boxes has four processors in each box? The way > we're running the cluster is Active/Passive. We are using SQL 2000 > Standard edition along with Enterprise edition of Microsoft Windows 2003 > Server. If someone could give me some insight I would highly appreciate > it. > > Thank you > Alex Anderson > > >
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread