Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Memory-Optimized Table Disk space Expand / Collapse
Author
Message
Posted Tuesday, April 22, 2014 10:56 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:59 PM
Points: 31,082, Visits: 15,529
Comments posted to this topic are about the item Memory-Optimized Table Disk space






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1564088
Posted Wednesday, April 23, 2014 12:25 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 12:01 AM
Points: 1,746, Visits: 763
Too easy thanks.

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1564108
Posted Wednesday, April 23, 2014 1:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:51 AM
Points: 1,284, Visits: 610
Had to do some quick searches to get it right, thanx.
Post #1564116
Posted Wednesday, April 23, 2014 4:28 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, September 25, 2014 12:36 AM
Points: 805, Visits: 1,404
Hany Helmy (4/23/2014)
Had to do some quick searches to get it right, thanx.


+1
Post #1564187
Posted Wednesday, April 23, 2014 6:42 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:05 PM
Points: 3,984, Visits: 5,237
Nice one, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1564230
Posted Wednesday, April 23, 2014 7:08 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:53 PM
Points: 1,899, Visits: 1,424
Easy one. Thanks Steve.



Everything is awesome!
Post #1564243
Posted Wednesday, April 23, 2014 8:28 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:48 PM
Points: 4,053, Visits: 3,490
I saw a presentation on this a while back and specifically remembered this. Honestly, I was hoping that it hadn't changed. Thanks for the question. I'm anxious to play with 2014, but I know it's going to be a while.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1564308
Posted Wednesday, April 23, 2014 9:32 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:57 PM
Points: 7,745, Visits: 9,493
I suspect this 2 times is only a rough estimate, as it appears to be directly contradicted by the BOL page Durability for Memory-Optimized Tables which states
BOL
Storage taken by active CFPs (not all CFPs are being updated) can be up to 2 times larger than the size of durable tables in memory
which clearly means three times the storage space may be needed on disc (it's two times larger, not just twice as large), which is confirmed towards the end of the same page by the statement
BOL
It is not uncommon for CFPs to be three times the size of the durable memory-optimized tables in memory.


Tom
Post #1564342
Posted Thursday, April 24, 2014 12:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
Nice question, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1564527
Posted Monday, April 28, 2014 6:58 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, September 15, 2014 11:49 AM
Points: 1,848, Visits: 587
easy one.
Post #1565559
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse