SQL Server with Mr. Denny

Jun 4 2014   4:00PM GMT

Hekaton and Your Transaction Log

Denny Cherry Denny Cherry Profile: Denny Cherry

Tags:
SQL performance
SQL Server
SQL Server 2014
SQL Server transaction logs
Transaction Log

Hekaton (aka. In Memory OLTP Tables) is awesome. Things run very fast through the system, pushing you to 98x the speed of normal tables.

But be careful. You’ll need to know well in advance how much transaction log space you are going to need. You see there’s a little gotcha that I ran into recently (thankfully in a lab and not a production server). If the transaction log fills because say the hard drive of the server runs out of drive space, the transactions don’t fail to write, the database goes suspect.

Neat trick hugh.

So you’ll want to make VERY sure that you’ve got PLENTY of disk space for the transaction log and that you are backing that bad boy up often otherwise some really bad things are going to happen.

You’ll need to be even more careful if you are using Availability Groups as the Availability Groups feature queues up the data which needs to be replicated within the transaction log. So if a replica goes offline for a while you’ll need to have enough space on all the servers for the transaction log to grow until someone can get to the Availability Group and take the failed replica out of the configuration.

Denny

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: