Home Forums SQL Server 2008 SQL Server Newbies Slows system performance RE: Slows system performance

  • April 10, 2013 at 3:12 am

    #1605135

    Krishna1 (4/10/2013)

    thanks. I will check the perfromace and the size of log after adding the checkpoint

    How do u write it,

    Begin tran

    Commit tran

    checkpoint

    if i have 2 begin tran / commot tran then i have to put chekcpoint 2 times?

    Yes, that's correct. Successful transactions in the tran log are of no further interest to you in simple recovery mode. SQL Server will get around to checkpointing in its own good time but you don't want to wait, you want the log space to be reusable for the next batch.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden