Post reply

Process blocked

  • March 27, 2010 at 6:26 am

    #97261

    Hi,

    I found in SQL SERVER CENTRAL in script tags for an identified blocking process and send email alert cdosysmail via smtp server. It is working fine in one single server. (this is test server have smtp email facility)

    please suggestion. This test server will gather blocked process from all remote server to centeralize one.

    Thanks in advance

  • March 27, 2010 at 8:35 am

    #1140937

    Sorry, I don't understand the question. What is it that you're looking for?

    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

  • March 27, 2010 at 10:58 am

    #1140945

    There are several thousand scripts here at SQL Server Central, could you please indicate exactly which one you mean?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • March 29, 2010 at 12:19 am

    #1141195

    Thanks for reply me..

    Script name : MONITOR_LOCKS, this is working fine in stand alone server and getting email alert when process being blocked with SPID.

    How can I monitor process being blocked & connect for all remote server?

    Thanks.

  • March 29, 2010 at 1:34 am

    #1141224

    Hi Ananda,

    If you are using 2008, please refer to below info-

    Central Management Servers

    SQL Server 2008 introduces a new method of administering multiple servers by enabling you to designate Central Management Servers. An instance of SQL Server that is designated as a Central Management Server maintains a list registered servers. For more information,

    see -

    http://msdn.microsoft.com/en-us/library/bb895144.aspx

  • March 29, 2010 at 4:44 am

    #1141302

    Hi Vidya thanks for your reply.....

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

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