SQL Server is a very versatile product in respect to licensing, you can buy and deploy SQL in either Server and CAL mode or Per Processor mode!
Lets look at the line-up for SQL Server before we break into the licensing
SQL Express is Free of charge, limited to 4GB Database
SQL Workgroup Edition is the easiest to use and most affordable solution for smaller departments and growing businesses, Workgroup is available in Server + 5 CAL bundles, individual CALs, and Per Processor licenses, Workgroup has it’s own CALs called Workgroup CALs. Workgroup CALs can only be used with Workgroup Edition.
SQL Standard and Enterprise are licensed Per Server and CAL or Per Proc
SQL CALs can be used with any Edition of SQL Server 2005.
Licensing of SQL Server 2005:
SQL in Per Server and CAL Mode – Licensing rules For SQL Server 2005 Workgroup and Standard Editions:
Running Instances of the Server Software. For each server software license you assign, you may run any number of instances of the server software in one physical or virtual operating system environment on the licensed server at a time.
SQL in Per Server and CAL Mode – Licensing rules For SQL Server 2005 Enterprise Edition:
Running Instances of the Server Software. You have the following right for each server to which you assign a software license. You may run, at any one time, any number of instances of the server software in one physical and any number of virtual operating system environments on that server.
SQL in Per Processor Mode – Licensing rules for SQL Server 2005 Workgroup and Standard Editions:
For each server to which you have assigned the required number of software licenses, you may run, at any one time, any number of instances of the server software in physical and virtual operating system environments on the licensed server. However, the total number of physical and virtual processors used by those operating system environments cannot exceed the number of software licenses assigned to that server
SQL in Per Processor Mode – Licensing rules for SQL Server 2005 Enterprise Edition:
Running Instances of the Server Software. If you assign to a server licenses equal to the total number of physical processors on the server you may run, at any one time, any number of instances of the server software in one physical and any number of virtual operating system environments on that server, you do not need to license virtual processors.
In certain circumstances one mode will outweigh the other, as an example, if SQL is on the back end of a Web server were external connections are made directly or indirectly to the SQL server, Per proc is the best method, simply because it would be quite expensive to cover from a CAL perspective and hard to establish compliancy from a connections perspective, SQL Per Proc negates the need for SQL CALs and permits unlimited connections to the SQL Server for inside or outside the firewall
Things that make SQL unique
- SQL Server is the only product that offers two models – Server/Cal AND Per Processor
- Multiplexing is a very frequent scenario with SQL Server
- Passive Servers/Failover support is allowed for “free”
- Multi-instancing is free
- Virtualization is unlimited and free for 2005 Enterprise Edition
- SQL Server does not charge for Multi-core
- SQL Server participates in SPLA and ISV Royalty programs
Per Server and CAL – SQL 2005 Server Enterprise
Provides any number of instances of the SQL server software in any number of virtual operating system environments on that server
Per Proc -SQL Server 2005 Enterprise Edition Capped at the Physical Processor count = Free Virtual Procs!
SQL 2005 SP2 EE is now capped at the physical processor count, the benefits of this is easiest to see visual, example below:
Note: In this example we have 4 Physical Processors and 8 Virtual Processors, if this was SQL Standard or WG edition the count would be 8xSQL Per proc licenses, but as its SQL 2005 EE the count is 4xPer Proc licenses to cover the licensing requirements
Did you know: If you install components on a separate server please be advised as below
Licensing Servers with running components. In Scenario 1, a SQL server is running with all of its components in one server: only one license is required. In Scenario 2, the database is running in one server, analysis services in a second one, and reporting services in a third one. In this case, three server licenses are required.
Next Post on Fail-Over Rights, Multi-instances, Multi-Core……………