MSBI Tutor

About this event Title: How to Troubleshoot a Slow Running Query in SQL Server & Azure SQL Abstract: You always wanted to troubleshoot a slow running query. But you just don’t know where to begin. In this demo-heavy session, I will show you how to troubleshoot a slow running query. You will see an end-to-end query tuning example with a slow running workload. We will capture important metrics while the workload is running and then use the captured data to troubleshoot query performance issues. The technique you will learn can be applied to production straight away. This will be a 100% demo session.    Register :  how-to-troubleshoot-a-slow-running-query-in-sql-server-azure-sql

Session Abstract: Many developers don’t pay attention to database performance when implementing new applications. The functionality of the application is important, but the efficiency of the SQL queries is often ignored. The DBA (or the query optimizer) does this job later. If necessary, we can still create some indexes, add hints or adjust some database parameters. And in the Cloud, the Oracle database does everything automatically and autonomously, anyway. Really? Unfortunately, the reality looks different. Many performance problems are caused by a poor software design, unsuitable data models, or inefficient SQL statements. Correcting such issues at the end of a project or when the system is already in operation is often very costly and cannot be fixed with just a few configuration parameters. With SQL live demos (all based on James Bond characters and movies), multiple-choice questions, and some funny stories that happened to me in my job as an Oracle consultant, I will explain why ...