Automate notification of blocked process report
hi,
have enabled blocked_process_report option in ss 2008 , able use sql server profiler information blocked processes. question if possible build kind of notification service when these blocks arose. have e.g. email sent our people responsible notifications. there table polled can same same information blocked_process_report using.
found following resource: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/04/06/event-notifications-monitoring-blocked-processes-and-other-events-end-to-end-how-to-set-it-up-and-make-it-work.aspx . in ss 2008 notification service not available more. approach or there other solution?
best regards
lars
have enabled blocked_process_report option in ss 2008 , able use sql server profiler information blocked processes. question if possible build kind of notification service when these blocks arose. have e.g. email sent our people responsible notifications. there table polled can same same information blocked_process_report using.
found following resource: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/04/06/event-notifications-monitoring-blocked-processes-and-other-events-end-to-end-how-to-set-it-up-and-make-it-work.aspx . in ss 2008 notification service not available more. approach or there other solution?
best regards
lars
lars,
tony's example doesn't use notification services. uses event notifications (whihc in turn uses service broker), both of available on 2008.
tibor karaszi, sql server mvp http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
tony's example doesn't use notification services. uses event notifications (whihc in turn uses service broker), both of available on 2008.
tibor karaszi, sql server mvp http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
SQL Server > SQL Server High Availability and Disaster Recovery
Comments
Post a Comment