Post reply

High CPU after T-SQL failed.

  • October 8, 2009 at 2:57 am

    #1063301

    The quick question to this, is can you break up the inserts and deletes into smaller batchs/transactions.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • October 8, 2009 at 3:08 am

    #1063306

    Thanks for the reply

    That is my 1st plan to try and resolve this.. But what im not understanding when I simulate a failure in my Dev AND QA env it rolls back ok with none of the symptoms that appear on the live server.

    Cheers

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply