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 ««12

Memory-Optimized Table checkpoint Expand / Collapse
Author
Message
Posted Monday, April 28, 2014 6:56 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 2,063, Visits: 3,385
Great question, very interesting!
I wouldn't have guessed that.
Post #1565558
Posted Monday, April 28, 2014 7:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 25, 2016 7:23 AM
Points: 2,456, Visits: 1,108
Raghavendra Mudugal (4/28/2014)
Thank you for the post,SJ, good one.

With the help of this link http://msdn.microsoft.com/en-us/library/dn553124(v=sql.120).aspx, i was able to pick the right answer, most of the time i took in finding the relevent link than understanding the question...

+1
Post #1565576
Posted Monday, April 28, 2014 7:54 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 9,949, Visits: 9,347
Had to do research on something new. Thanks for the question.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1565584
Posted Monday, April 28, 2014 8:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, May 31, 2016 4:13 PM
Points: 2,107, Visits: 2,254
Kind of disturbing to see that 36% (as of now) think a checkpoint is taken after every completed transaction.

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1565588
Posted Monday, April 28, 2014 1:23 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 5:31 PM
Points: 4,133, Visits: 2,325
Thomas Abraham (4/28/2014)
Kind of disturbing to see that 36% (as of now) think a checkpoint is taken after every completed transaction.


Imagine what that would look like in a busy OLTP system!

Thanks for the 2014 question, Steve.
Post #1565688
Posted Monday, April 28, 2014 6:38 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 4:00 PM
Points: 9,824, Visits: 11,895
Nice question.

Thomas Abraham (4/28/2014)
Kind of disturbing to see that 36% (as of now) think a checkpoint is taken after every completed transaction.


It's getting worse - it's now grown to 37%.

Seems to me that the growth amount should be user configurable rather than a fixed 512 MB. But maybe MS are thinking that allowing users to configure that would give them another way to wreck the system?


Tom
Post #1565741
Posted Tuesday, April 29, 2014 2:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:14 AM
Points: 5,362, Visits: 7,070
TomThomson (4/28/2014)
Nice question.

Thomas Abraham (4/28/2014)
Kind of disturbing to see that 36% (as of now) think a checkpoint is taken after every completed transaction.


It's getting worse - it's now grown to 37%.

Seems to me that the growth amount should be user configurable rather than a fixed 512 MB. But maybe MS are thinking that allowing users to configure that would give them another way to wreck the system?

+1


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1565797
Posted Thursday, May 1, 2014 12:13 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Monday, November 21, 2016 11:03 AM
Points: 20,009, Visits: 18,255
Excellent question



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1566820
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse