Fine Tuning Clouds: Azure SQL Database Performance Tuning Tips and Tricks
Performance tuning might be seen as magic, and those who can tune might look like magicians. There are no “go-faster” buttons and in reality, performance tuning is more art than magic. In this session we share common performance issues seen by various customers while using Azure SQL Database, and possible ways to fix them. You will learn database tuning techniques to gain the best performance for your application. While there are many tips and tricks available for traditional SQL Server installations, there are additional tuning best practices specific to Azure SQL Database. This session covers efficient data loading, dealing with high resource consumption, practical usage of various DMVs and various diagnostic telemetry available to look back in time.