Crud Tests Test Cases

PRINT 'Start CrudTest_TempTable ' + (CONVERT( VARCHAR(24), GETDATE(), 121))
GO

CrudTest_TempTable 1000, 100, 100
GO 1000
--with transaction 6.5s
--without transaction 13s

PRINT 'Finish CrudTest_TempTable ' + (CONVERT( VARCHAR(24), GETDATE(), 121))
PRINT 'Start CrudTest_SpidFilter_memopt_hash ' + (CONVERT( VARCHAR(24), GETDATE(), 121))
GO

CrudTest_SpidFilter_memopt_hash 1000, 100, 100
GO 1000
--with transaction 18s - almost no io as expected
--without transaction more than 120s, high io!

PRINT 'Finish CrudTest_SpidFilter_memopt_hash ' + (CONVERT( VARCHAR(24), GETDATE(), 121))
PRINT 'Start CrudTest_memopt_hash ' + (CONVERT( VARCHAR(24), GETDATE(), 121))
GO

CrudTest_memopt_hash 1000, 100, 100
GO 1000
--atomic native compilation 12.5s

PRINT 'Finish CrudTest_memopt_hash ' + (CONVERT( VARCHAR(24), GETDATE(), 121))
PRINT 'Start CrudTest_tableVar ' + (CONVERT( VARCHAR(24), GETDATE(), 121))
GO

CrudTest_tableVar 1000, 100, 100
GO 1000
--with transaction 4.5s
--without transaction 4.5
--atomic native compilation 1.5s

PRINT 'Finish CrudTest_tableVar ' + (CONVERT( VARCHAR(24), GETDATE(), 121))
GO