SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Anyone Using or Planning to Use Memory-Optimized Tables?


Anyone Using or Planning to Use Memory-Optimized Tables?

Author
Message
Michael Valentine Jones
Michael Valentine Jones
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5692 Visits: 11771
I was just wondering if this feature will be used in the real world.

Not being able to have identity columns and foreign key constraints looks like a major drawback, so I wonder if it will be used for anything besides generating impressive TPC tests for Microsoft.
Eirikur Eiriksson
Eirikur Eiriksson
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14924 Visits: 18591
I do have plans for implementation but still kind of struggling how to fit this into the architecture. There are certain benefits but the question is more how to fit these into the big picture with a tangible ROI. As it stands, I'm looking at a least few months of parallel operation before I'll make any comments. As you mentioned, there are drawbacks and at least from my standpoints, those are significant.
Cool
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)

Group: General Forum Members
Points: 85102 Visits: 41077
Michael Valentine Jones (4/28/2014)
I was just wondering if this feature will be used in the real world.

Not being able to have identity columns and foreign key constraints looks like a major drawback, so I wonder if it will be used for anything besides generating impressive TPC tests for Microsoft.


For the very reasons you mention and more, no... I have no plans to use Hekaton for at least the foreseeable future.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Grant Fritchey
Grant Fritchey
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39324 Visits: 32622
The thing is, I think the technology is amazing, but, it's really all about the ability to collect data and feed data out at high speed in an OLTP environment. Way too many people are going to think that it solves all sorts of problems that it doesn't. It's not a panacea. In fact, it's extremely focused in the problems it can solve. But, I think it solves those problems well. But, again, you have to have big enough machines to really make it work. We're still getting all sorts of questions from people running on an 8gb server. They're not going to implement in-memory anything any time soon. It's a niche solution, albeit a pretty cool one. But no, no immediate plans because we're no where near the target audience and don't have the kind of hardware necessary to make the whole thing work.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
mike.murphy 11169
mike.murphy 11169
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 98
No plans here so far. We looked into it, the problem would be there is not a way to add a where clause for the memory table. (hint: Microsoft). Our problem is we would be dealing with mass amounts of data, but we would only be interested in say the most current 3 months transactions for a particular customer as opposed to dealing with the entire customers history.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86588 Visits: 45245
No plans, but I have advised two clients to consider replacing SQL 2012 with SQL 2014 in their upgrade plans. Partially because, knowing these guys, they won't actually upgrade until around 2016, but also so that I can consider Hekaton for very specific, very carefully targeted portions of their systems.

Not that they're in any way at the point that there are no other performance gains to be had. Hell, most databases I see it's a combo of 'Did a cat throw up on that stored proc, or did you write it that way?', 'Indexes? What are they?' and '2003 called and would like its hardware back' Hehe

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)

Group: General Forum Members
Points: 85102 Visits: 41077
Grant Fritchey (4/29/2014)
The thing is, I think the technology is amazing, but, it's really all about the ability to collect data and feed data out at high speed in an OLTP environment. Way too many people are going to think that it solves all sorts of problems that it doesn't. It's not a panacea. In fact, it's extremely focused in the problems it can solve. But, I think it solves those problems well. But, again, you have to have big enough machines to really make it work. We're still getting all sorts of questions from people running on an 8gb server. They're not going to implement in-memory anything any time soon. It's a niche solution, albeit a pretty cool one. But no, no immediate plans because we're no where near the target audience and don't have the kind of hardware necessary to make the whole thing work.


I absolutely agree. It is both a niche and nice solution for high speed OLTP and a lot of people are thinking of it more as a general purpose RAM disk, which it isn't. It's very targeted and does well for what it was designed for. I do wish it had IDENTITY column capabilites, though.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeremy Brown
Jeremy Brown
Old Hand
Old Hand (315 reputation)Old Hand (315 reputation)Old Hand (315 reputation)Old Hand (315 reputation)Old Hand (315 reputation)Old Hand (315 reputation)Old Hand (315 reputation)Old Hand (315 reputation)

Group: General Forum Members
Points: 315 Visits: 310
From what I understand, if you convert any table to use the clustered columnstore format, you're implicitly using this. It stores the first 10k rows (I believe) in the in-memory OLTP table then uses a tuple mover to move it to the columnstore. Hence its "updatable".



jfogel
jfogel
SSChasing Mays
SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)

Group: General Forum Members
Points: 641 Visits: 1168
No. I did some testing with it and found the performance increase to be very nice. However, in order to get the tables involved to comply with requirements they basically had to be modified in many ways. That would mean the application(s) would have to be modified as well. None of that is going to happen anytime soon. There is also the question of memory for the server itself. In order to really load up we would need to move to the Enterpri$e Edition and the cost are just not something we are going to deal with at this point. Things like a SAN are way ahead of that.

Cheers
S. Kusen
S. Kusen
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1574 Visits: 1117
Anyone think that a good use case for a Hekaton table would be for the ASPSession database tables? Obviously there are alternatives to caching session data, but for those using SQL, it might be a good solution (if the FK's and identity cols don't exist.. not on my work computer at the moment to check for those in that DB).
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search