Post reply

Performance -Blocking and Deadlocks

  • August 26, 2010 at 4:25 pm

    #226944

    Hello Everybody,

    Dudes I have lot of issues regarding the bottlenecks

    Processor: %processortime =100% in busy business hours.

    Process : %process = 100%

    I do have a lot blocking due to

    700 to 1400 processes running at a time ,

    Lot of wait_type

    CXPACKET

    THREADPOOL

    CHECKPOINT_QUEUE---DB IN SIMPLE RECOVERY MODEL.

    AND MORE OTHER WAIT TYPES,

    Thanks a lot if you help me...........

    I did changed recovery interval to 1 minute for Checkpoint_queue

    I have max worker threads set to 960

    I have parallelism because my maxdop set to '0'-default.

    Please let me know how I get down my processor to atleast below 80%.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • August 26, 2010 at 4:30 pm

    #1212612

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 24, 2010 at 1:56 pm

    #1227216

    Hey Gilsha Thank you man for you rreply

    recently I solved almost all the issues

    by changing the configuration settings.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • September 24, 2010 at 9:52 pm

    #1227314

    pavan_srirangam (9/24/2010)

    Hey Gilsha Thank you man for you rreply

    recently I solved almost all the issues

    by changing the configuration settings.

    Would you mind sharing the settings you changed to resolve your issues? That might be helpful to someone else in the future.

  • October 11, 2010 at 4:07 pm

    #1235257

    I changed the MAXDOP setting to 1 that resolved CXPACKET waits this also brought my cpu down to normal.

    Added a new data file to avoid the the pagelatch_up waits.

    Tuned store procs that consuming high memory finded out using memory _usage dmv

    Post here if you have any related issues so that I can try to solve to the best.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

Viewing 5 posts - 1 through 4 (of 4 total)

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