Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: 2 days ago @ 7:24 PM
Points: 33,930, Visits: 18,039
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: Wednesday, January 20, 2016 3:52 PM
Points: 1,818, Visits: 836
Too easy thanks.

Hope this helps...

Ford Fairlane
Rock and Roll Detective





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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, May 15, 2016 12:12 AM
Points: 2,456, Visits: 1,107
Had to do some quick searches to get it right, thanx.
Post #1564116
Posted Wednesday, April 23, 2014 4:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 20, 2016 1:02 AM
Points: 1,258, Visits: 1,830
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:30 AM
Points: 5,160, Visits: 6,874
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:02 AM
Points: 2,200, Visits: 1,664
Easy one. Thanks Steve.



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

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 12:44 PM
Points: 9,166, Visits: 8,475
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:30 AM
Points: 9,530, Visits: 11,517
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 2:43 AM
Points: 15,240, Visits: 13,054
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 SQLKover.

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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, March 8, 2016 10:23 AM
Points: 2,144, Visits: 613
easy one.
Post #1565559
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse