Post reply

CPU Bottleneck

  • February 21, 2006 at 1:33 am

    #189349

    Hi Dear,

     

    How can i come to know what process is the culprit for CUP Bottleneck.

    As from system processor Queue length i got few bottlenecks but dont know exactly how to fetch for teh query creating this bottleneck.

     

    from

    Killer

  • February 21, 2006 at 8:54 am

    #622318

    Check this..but for temp tables

    http://www.sql-server-performance.com/nb_avoid_bottlenecks.asp

    Get busy living ....or get busy dying....

  • February 21, 2006 at 8:45 pm

    #622504

    Dear Arul,

    Related to sql server2000.

     

    from

    Killer

     

     

  • February 21, 2006 at 9:59 pm

    #622510

    First point of call would be to use the Process object in System Monitor and determine if SQL is using the CPU.

    A high processor Queue length could be caused by other processes running on the system.

    Be sure to take a look a the many performance monitoring articles available at

    http://www.sql-server-performance.com

     

    --------------------
    Colt 45 - the original point and click interface

  • February 21, 2006 at 10:05 pm

    #622514

    Hi,

    See your query execution plan for Hash joins, large sort operation, frequent recompile of sp.. etc. They may be the culprits

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

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

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