We are planing to deploy 3 SQL Server instances on 2 node cluster setup. All 3 instance will run one either one node 1 or node2 or some on node 1 & some on node2. We are having 8 physical processor servers
1) Please help in understanding the requirement of licenses
2) Is the license requirement same for enterprise & standard edition
If you have an active/passive setup you can get away with licensing only the active node, as I recall you get 30 days or so post failover before you need a license on the passive node. In the case you describe above you will need to license both nodes since
you have an "active/active" setup. You need to investigate the official licensing documentation to decide whether you use per processor or per user cal etc. You may also want to revisit your hardware selection regarding number of processors (8 in your case) since
this can have a major effect on licensing cost.
Regarding editions standard edition and enterprise edition are completely different licenses, you cannot purchase a standard edition license and run enterprise edition, you will want to get quotes and then decide whether the additional enterprise features exceed
your cost/benefit threshold. There is a lot of info. on the web or you can talk to Microsoft/your licensing provider for more info. Assuming you are looking at SQL Server 2008 R2 have a look at the following for an idea of price and also see the other documents
linked to at the bottom...
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.