sql server notification services: sql server locks alerts. -- sql server notification services

sql server locks alerts.

Maria Isabel Guzman
12/1/2004 2:47:44 PM

sql server notification services: Hi, we are implementing a new application that use sql server as
database. We are experimenting some locks when some users execute large
transactions. We need to implement alerts that tell us when a user is
blocking other users before a deadlocks occures.

Now we know that someone is blocking when the users call us, but we want
to detect it before the call.

do any body can tell me how to implement this alerts??

thanks a lot for your help.

*** Sent via Developersdex http://www.developersdex.com ***

Re: sql server locks alerts.

Joe Webb
12/2/2004 5:44:12 AM

Notification Services would probably be overkill for this type of
application. Consider using the built in alerts as you suggested
(another newsgroup).

HTH...
Joe Webb

~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

[quoted text, click to view]

Re: sql server locks alerts.

avnrao
12/2/2004 4:24:23 PM

hey you can use SQLServerEvent provider and poll for

Select * from master..sysprocesses where blocked <> 0
and use notification services to send notifications.

on how to implement NS applications
http://www28.brinkster.com/avdotnet - check 2 articles here
http://www.microsoft.com/sql/ns - for complete informatino on NS.

Av.
http://dotnetjunkies.com/WebLog/avnrao
http://www28.brinkster.com/avdotnet

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server notification services group.