Post reply

resolving blocking automatically

  • April 25, 2007 at 7:59 pm

    #62651

    is it possible to automatically identify a block situation and kill one of the spids after a certain time? and which spids should be killed? and how can it be automated?

  • April 26, 2007 at 5:09 am

    #702567

    Hi,

    It's possible to monitor the current activity by either capturing the results of sp_who2 or querying the sysprocesses and syslocks/syslockinfo tables.

    I would be careful about automatically killing processes. Also, what factors are you considering for which spid gets killed?


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • April 26, 2007 at 8:34 am

    #702619

    whenever a block occurs during the day and its over 10 minutes. can you create a  daemon or agent that can run constantly to look for these activities?

  • April 27, 2007 at 7:22 am

    #702915

    I would be careful about automatically killing SPID's that are blocked or blocking. Doing that is just treating the symptom and not solving the problem.

    Find out what queries are causing the blocking issues and try to fix those first if you can.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;224453

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

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