use msdb;
set xact_abort, nocount on;
go

print @@version;

create table dbo.tr (id tinyint, description varchar(30), elapsed_time int, log_bytes_used bigint);

create table dbo.t1 (id int identity, s varchar(50));
alter table dbo.t1 add constraint PK_t1 primary key clustered (id);

create table dbo.t2 (id int identity, s varchar(50));
alter table dbo.t2 add constraint PK_t2 primary key clustered (id) with (data_compression = page);

create table dbo.t3 (id int identity, s varchar(50));
alter table dbo.t3 add constraint PK_t3 primary key clustered (id) with (data_compression = row);
go

declare @dt datetime2 = sysdatetime(), @c int = 1000000;

begin tran;

while @c > 0
 begin
  insert into dbo.t1 values (cast(newid() as varchar(36)));
  select @c -= 1;
 end;

insert into dbo.tr
select
 1, 'data_compression = none', datediff(ms, @dt, sysdatetime()), sum(dbt.database_transaction_log_bytes_used + dbt.database_transaction_log_bytes_used_system)
from
 sys.dm_tran_current_transaction ct join
 sys.dm_tran_database_transactions dbt on dbt.transaction_id = ct.transaction_id

commit;
go

declare @dt datetime2 = sysdatetime(), @c int = 1000000;

begin tran;

while @c > 0
 begin
  insert into dbo.t2 values (cast(newid() as varchar(36)));
  select @c -= 1;
 end;

insert into dbo.tr
select
 2, 'data_compression = page', datediff(ms, @dt, sysdatetime()), sum(dbt.database_transaction_log_bytes_used + dbt.database_transaction_log_bytes_used_system)
from
 sys.dm_tran_current_transaction ct join
 sys.dm_tran_database_transactions dbt on dbt.transaction_id = ct.transaction_id

commit;
go


declare @dt datetime2 = sysdatetime(), @c int = 1000000;

begin tran;

while @c > 0
 begin
  insert into dbo.t3 values (cast(newid() as varchar(36)));
  select @c -= 1;
 end;

insert into dbo.tr
select
 3, 'data_compression = row', datediff(ms, @dt, sysdatetime()), sum(dbt.database_transaction_log_bytes_used + dbt.database_transaction_log_bytes_used_system)
from
 sys.dm_tran_current_transaction ct join
 sys.dm_tran_database_transactions dbt on dbt.transaction_id = ct.transaction_id

commit;
go

select
 tr.*,
 cast(tr.elapsed_time * 100. / a.min_elapsed_time - 100. as money) elapsed_time_impact_percent,
 cast(tr.log_bytes_used * 100. / a.max_log_bytes_used - 100. as money) log_bytes_used_impact_percent
from
 dbo.tr cross apply
 (select min(elapsed_time), min(log_bytes_used) from dbo.tr) a(min_elapsed_time, max_log_bytes_used)
order
 by id;
go

drop table dbo.tr, dbo.t1, dbo.t2, dbo.t3;
go

Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64) 
	Mar 19 2015 12:32:14 
	Copyright (c) Microsoft Corporation
	Developer Edition (64-bit) on Windows NT 6.3 <X64> (Build 17134: ) (Hypervisor)