Post reply

Block problem !

  • February 16, 2012 at 2:04 am

    #250761

    Hi all my friend,

    I have a very big problem. I have found many performance problem of our system.

    I can fix all but except of one. Tunning many queries, indexes, relation of tables etc..

    There is one more problem that is last. I catch a query which is take 20 million record

    and system is halt. I can see this query on Activity monitor and sql server User name

    but no host name. When it runs there are many block processes. I think it is possible

    Crystal Report query. I can not understand Who is call this query and where from in the

    code behind. There is no where condition in query. I search all project files, crystal report

    files but there is no any query like this.

    Please advise me how to find a way.

    Thanks..

  • February 16, 2012 at 2:16 am

    #1447706

    try to find host name of correspinding session_id in below dmv

    sys.dm_exec_connections, sys.dm_exec_sessions

    java

  • February 16, 2012 at 2:29 am

    #1447710

    Thanks my friend, I will try it once system is block.

    I want to ask a question.

    Is there any way when a process block the others, automatically kill it ?

  • February 16, 2012 at 3:01 am

    #1447721

    orkun çapraz (2/16/2012)

    Thanks my friend, I will try it once system is block.

    I want to ask a question.

    Is there any way when a process block the others, automatically kill it ?

    Blocking is essential for data integrity and transactional consistency. Killing all processes that block others would mean disallowing cuncurrency.

    Personally, I would set a command timeout on the application side. IIRC, Crystal Reports should let you set that value.

    -- Gianluca Sartori

  • February 16, 2012 at 3:44 am

    #1447745

    Chapter 6: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

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

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