Tracking server activity without slowing performance
All SQL Server DBAs should know how Service Broker and Event Notifications work so that they can implement this very simple feature to make sure they are aware of events happening on their servers.
Event Notifications is a very light-weight, asynchronous mechanism for identifying events and taking actions. In this session we will create sessions to monitor for and act on DDL changes, file size changes, index and statistics changes, security changes and more. Attendees will gain an understanding of how they can monitor many servers and stay in control.
Sorry, there are no downloads available for this session.
Jonathan has been working with SQL Server since 1999. He enjoys performance tuning, development and using SQL Server to provide appropriate business solutions. He is the founder and leader of the PASS SQLSouthWest user group (http://www.sqlsouthwest.co.uk) and enjoys blogging about it all for Simple Talk.
The video is not available to view online.