Friday, February 24, 2012

about set an alert that is about blocking

Hi Guys,
I wonder if there is a way that I can setup an alert when there are some
tables are blocking for a long time? That mean I can get email or call when
blocking is occurred. Thanks.Iter
In SQL Server 2005
Execute Sp_configure blocked process threshold, 200
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
> Hi Guys,
> I wonder if there is a way that I can setup an alert when there are some
> tables are blocking for a long time? That mean I can get email or call
> when
> blocking is occurred. Thanks.|||Thank you very much. Is there any solution in SQL server 2000?
"Uri Dimant" wrote:

> Iter
> In SQL Server 2005
> Execute Sp_configure ‘blocked process threshold’, 200
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
>
>

No comments:

Post a Comment