Main Content

SQL Server 2016 – Performance Troubleshooting with Query Store and Live Query Plan

About the Talk

April 23, 2016 10:00 AM

Bangalore, India

Bangalore, India

SQL Server 2016 – Performance Troubleshooting with Query Store and Live Query Plan by Devashish Salgaonkar (Microsoft) Abstract: Have you ever – Had your system down/slowed down and everyone waiting for you to magically fix the problem ASAP? Upgraded an application to the latest SQL Server version and had an issue with a plan change slowing your application down? Had a problem with your Azure SQL Database and been unable to determine what was going wrong? ..Then this session is just for you! In this session, we will familiarize you to the new and powerful feature announced in SQL Server 2016 – Query Store. This feature will be provide greater insights into query execution patterns enabling them to troubleshoot query performance issues more efficiently. The following topics will be covered as part of the session –

Introduction Key Usage Scenarios Query Store Architecture Accessing Query store information using Reports and Queries Live Query Plan

Ratings and Recommendations

This Talk hasn't been rated yet. Sign In to rate Talks.

comments powered by Disqus