SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 2014: Delayed Durability
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ferrethouse
Constraint Violating Yak Guru

340 Posts

Posted - 05/27/2014 :  11:27:49  Show Profile  Reply with Quote
I've been playing around with this new feature in 2014 and have had amazing performance improvements for writes.

When delayed durability is turned on I do 10,000 individual writes in 1.4 seconds. With it turned off it takes 15 seconds.

I'm not overly concerned about possible data loss (which would be minimal if RAM was flushed) but I am concerned because my tlog became corrupt last night after having turned it on. I don't know if it is a coincidence. Anyone have any experience using it?

SwePeso
Patron Saint of Lost Yaks

Sweden
30105 Posts

Posted - 05/27/2014 :  14:26:52  Show Profile  Visit SwePeso's Homepage  Reply with Quote
The only drawback is if tlog writes takes that long and application have continued and suddenly tlog is rolling back.
Could be a bummer and difficult to handle. But it would only be in the case if tlog is completely full.


Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000