Search results matching tags 'Infrastructure', 'Tools', 'Best Practices', 'Performance', and 'Automation'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Infrastructure,Tools,Best+Practices,Performance,Automation&orTags=0Search results matching tags 'Infrastructure', 'Tools', 'Best Practices', 'Performance', and 'Automation'en-USCommunityServer 2.1 SP2 (Build: 61129.1)New White Paper: SQL Server Extended Events and Notificationshttp://sqlblog.com/blogs/kevin_kline/archive/2012/04/25/new-white-paper-sql-server-extended-events-and-notifications.aspxWed, 25 Apr 2012 13:13:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:42932KKline<p>SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred. &nbsp;There's PerfMon, and Profiler, and loads of Dynamic Management Views to check. &nbsp;But where to look?</p><p>As database administrators (DBA), we need to monitor our environments proactively and create solutions as issues arise. In this white paper, we will look at a couple technologies – event notifications and extended events – that can help you achieve these goals. With these two features, we’ll look at the error log and deadlocks, and demonstrate how you can get relevant information delivered as it occurs. We’ll also look at ways that run-time errors can be captured and used to help reduce the amount of time required to investigate issues.</p><p>This white paper, written by SQL Server MVP Jason Strate (<a title="Jason Strate's SQL Server Blog" href="http://www.jasonstrate.com/">blog</a>&nbsp;|&nbsp;<a title="Jason Strate's Twitter Feed" href="http://twitter.com/stratesql">twitter</a>), is a free download <em>but requires a registration</em>.&nbsp; <a title="Microsoft SQL Server Extended Events White Paper" href="http://www.quest.com/whitepaper/how-to-use-sql-servers-extended-events-and-notifications816315.aspx">Download the Extended Events white paper here</a>.</p><p>And, as always, I enjoy your feedback. &nbsp;Thanks!</p><p>-Kev</p><p>&nbsp;Follow me on&nbsp;<a title="Kevin Kline's Twitter Feed" href="http://twitter.com/kekline">Twitter</a>!</p>