SQL Server Performance

Monitoring SQL Server

Discussion in 'Performance Tuning for Hardware Configurations' started by cyvert2005, Oct 26, 2006.

  1. cyvert2005 New Member

    Sorry, I'd to know, how can i fix my bottleneck, because i'm having a lot of time outs with my system.

    forgime my grammar I don´t speak english very well

    thank´s for you attentions
    cyvert2005, Oct 26, 2006
    #2

  2. Madhivanan Moderator

    Madhivanan, Oct 26, 2006
    #2

  3. ghemant Moderator

    Hi,
    as suggested refer links and in addition
    1). Run profiler trace and refer the longest running queries
    2). ensure if any bloking issue
    3). ensure developers has properly commit/rollback transaction.
    4). See if the application is not written poorly.
    5). See if any Hardware/Network problem.

    HTH
    Regards

    Hemantgiri S. Goswami
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
    ------------------------
    http://hemantgirisgoswami.blogspot.com
    ghemant, Oct 27, 2006
    #2

  4. satya Moderator

    Timeout might occur due to blocking on system, so check whether if that is happening by running SP_WHO2 and check for BlkBy columns. Additional reading for you on blocking:
    http://www.sql-server-performance.com/blocking.asp
    http://www.sql-server-performance.com/sf_block_prevention.asp
    KBAhttp://support.microsoft.com/kb/271509
    http://support.microsoft.com/kb/263889

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
    satya, Oct 27, 2006
    #2

Share This Page