/*
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'

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

quote:

---

Originally posted by tkizer

Your prices are interesting.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

---