Not a big deal, but this script is handy to have if you are trying to decide how to license SQL Server.
You could do this with Excel, but this is a SQL Server site.
/*
Calculate_SQL_CAL_Break_Even.sql
Description: Script to calculate the break even point for Processor vs. Server/CAL licensing
To use this script:
1. Enter the current Price_Per_Processor and Price_with_Server_CAL for each edition of SQL Server.
2. Enter the current CAL price.
3. Execute the script.
*/
set nocount on
declare @Edition table (
Edition varchar(10) not null primary key,
Price_Per_Processor numeric(10,2) not null,
Price_with_Server_CAL numeric(10,2) not null
)
declare @cal_price numeric(8,2)
-- Modify CAL price as needed
select @cal_price = 115.00
insert into @Edition
select Edition = 'Enterprise',
-- Modify price as needed
Price_Per_Processor = 18700.00,
-- Modify price as needed
Price_with_Server_CAL = 5800.00
union all
select Edition = 'Standard',
-- Modify price as needed
Price_Per_Processor = 4900.00,
-- Modify price as needed
Price_with_Server_CAL = 655.00
select
a.* ,
b.* ,
CAL_Price = @cal_price ,
CAL_Break_Even =
convert(int,floor(((Price_Per_Processor * Processor_Count) - Price_with_Server_CAL)/ @cal_price))
from
@Edition a
cross join
(
select Processor_Count = 1 union all
select Processor_Count = 2 union all
select Processor_Count = 3 union all
select Processor_Count = 4
) b
order by
a.Edition,
b.Processor_Count
print 'If CAL count > CAL_Break_Even, then processor license is cheaper.'
print ''
print 'Calculation for CAL_Break_Even = '
print ' ( ( Price_Per_Processor * Processor_Count ) - Price_with_Server_CAL ) / CAL_Price'
Sample Script Output:
Edition Price_Per_Processor Price_with_Server_CAL Processor_Count CAL_Price CAL_Break_Even
---------- ------------------- --------------------- --------------- ---------- --------------
Enterprise 18700.00 5800.00 1 115.00 112
Enterprise 18700.00 5800.00 2 115.00 274
Enterprise 18700.00 5800.00 3 115.00 437
Enterprise 18700.00 5800.00 4 115.00 600
Standard 4900.00 655.00 1 115.00 36
Standard 4900.00 655.00 2 115.00 79
Standard 4900.00 655.00 3 115.00 122
Standard 4900.00 655.00 4 115.00 164
If CAL count > CAL_Break_Even, then processor license is cheaper.
Calculation for CAL_Break_Even =
( ( Price_Per_Processor * Processor_Count ) - Price_with_Server_CAL ) / CAL_Price
CODO ERGO SUM
Calculate SQL CAL Break Even Point
Posted - 2010-11-30 : 12:08:36
