The DBA always faces challenges in troubleshooting live performance issues. In SQL Server 2016, two new features are introduced to help a DBA to be more productive.
The Query Store is a feature that will help in visualizing what is happening with your executing queries, which otherwise is hard to collect with DMVs. The UI rich interface makes it easier to troubleshoot live scenarios as well as collect data for troubleshooting. The magic just does not end with watching but actually using this to play around with execution plans.
Have you ever felt a need to see the execution plan when executing a query while troubleshooting? Live Query Statistics helps you view the live execution plan rather than waiting till end of the execution of query to see the execution plan. You will never have to wait again to say where your query execution is hurting.
About the presenter
Manohar Punna is a Senior SQL DBA by profession and is a community enthusiast by passion. He has been awarded as Microsoft MVP in July, 2015. He is the Vice President of SQLServerGeeks, the largest SQL community in Asia. Manohar is a speaker at various SQL Server Day events across India and at SQLBits. Manohar blogs about SQL Server at www.SQLServerGeeks.com and is the author of the One DMV a Day series which is longest one day series on any SQL Server topic till date. He maintains his own site www.ManoharPunna.com where he blogs about his life events and non-technical encounters.
This event is hosted by the Adelaide SQL Server User Group, and sponsored by LobsterPot Solutions
Join millions of people on Eventbrite.
In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.