19:30 Neil Hambly on Extended Events
20:45 Richard Douglas on Baselining Performance
Extended Events – New Age of Profiling
Extended Events is the replacement for profiler in many respects, and will be the choice of capturing data from within SQL Server now and in future editions,so we need to understand the differences it has to profiler "old guard" and why we should be using this new feature for this purpose I'll take you on a Guided tour of the key aspects, and show you simply how in just minutes you can up and running and capturing data using this new method and how to analyze it effectively Follow me to the "new age" of understanding your systems activity
The Day After Tomorrow - Why you need to Baseline
Ensuring top performance on your SQL Servers can be a major pain point for many organisations and a lot of hard work for the DBA team. To maintain top notch performance you need to make sure you are monitoring the right things, but how do you know if the figures you are seeing is good or bad? This is where comparing against a baseline for your environment is key.JoinRichard who will explain what a baseline is, why and when you need to take one and then will show you how to create one. We'll be looking at a number of native window and SQL Server tools that will allow you to do just that.
Neil Hambly is a Senior DBA @ Confio Software, having held various SQL Server roles during the last 14 years @ market leading companies (Accenture, ABN AMRO, BBC, iProfile, MDSL) He has considerable Experience in SQL Server starting with version 6.5 through to the latest 2012 release. A regular International speaker @ SQL conference & User Group, he also leads the SQL London PASS Chapter (UK). Frequently found studying the inner workings of SQL Server, as well as an avid Tweeter @Neil_Hambly.
Richard Douglas is a Systems Consultant for Dell specialising in SQL Server, he provides solutions and system health checks to organisations across the EMEA region. Richard has recently taken on the responsibility of being Editor in Chief of the community site SQLServerPedia which provides articles on SQL Server and a blog syndication service, other duties see him regularly presenting webinars to both US and EMEA audiences. He is also a keen member of the SQL Server community, he founded and runs a PASS affiliated chapter in the UK (www.SQLStudy.org), is on the organising committee for a national event called “SQL Relay”. He tweets from @SQLRich and blogs at http://SQL.RichardDouglas.co.uk