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

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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:32 AM
Points: 1,334, Visits: 2,299
Great question, very interesting!
I wouldn't have guessed that.
Post #1565558
Posted Monday, April 28, 2014 7:31 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:38 AM
Points: 1,263, Visits: 601
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
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:51 PM
Points: 3,999, Visits: 3,434
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, September 18, 2014 10:35 AM
Points: 1,825, Visits: 2,175
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


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 @ 11:30 AM
Points: 3,329, Visits: 1,991
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:51 PM
Points: 7,702, Visits: 9,432
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


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 @ 8:45 AM
Points: 3,969, Visits: 5,212
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 Wednesday, April 30, 2014 6:54 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:30 AM
Points: 2,947, Visits: 243
Thanks
Post #1566359
Posted Thursday, May 1, 2014 12:13 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 6:43 PM
Points: 17,655, Visits: 15,509
Excellent question



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1566820
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse