April 12, 2015 at 4:29 pm
Has anyone used HammerDB or Benchmark Factory and tried SQL 2014 in-memory? Wondering what schema or stored procedure changes would be necessary to make it happen.
April 13, 2015 at 5:10 am
You just have to make the calls to the in-memory objects. It's actually not very different at all from calling the regular tables. The one exception is when you have a natively compiled stored procedure, the preferred call mechanism is ordinal rather than by parameter. So this is preferred:
EXEC spMyCompiledProc 42, 'SomeValue', 42;
over
EXEC spMyCompiledProc @Param1 = 42, @Param2 = 'SomeValue', @Param3 = 42;
Except for that, once you've built in-memory tables, what you have are SQL Server tables. You make calls to them from your T-SQL within the limits of the types of queries that they support.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 13, 2015 at 9:31 am
That was the hope.
What I'm seeing is that there are lots of changes necessary - index modifications, hints in the stored procedures that need changing, had to add sequences and remove identity columns, and so on. That was in Benchmark Factory TPCC. I was hoping that someone else had gone through the pain and had all the scripts & changes out there.
April 13, 2015 at 9:34 am
The biggest part of the undertaking won't be making the calls to the objects. The biggest part of the work is all the modifications you'll have to make to all the internals for the objects that you're choosing to move to in-memory.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 16, 2015 at 12:16 pm
scb (4/12/2015)
Has anyone used HammerDB or Benchmark Factory and tried SQL 2014 in-memory? Wondering what schema or stored procedure changes would be necessary to make it happen.
Interesting on seeing how you used HammerDB, parameters, config, etc, with SQL2014. I'm about to do the same at work. Please reply with info.
Thanks,
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply