Even though the cloud provides elastic scale and seemingly infinite resources, you still have to design, monitor and tune performance. Microsoft Azure SQL Database has architectural differences from SQL Server and understanding how these can impact performance is critical. In this session, Microsoft Azure MVP, Eric D. Boyd, will show you how you can identify bottlenecks and the cause of performance problems in SQL Database. This session will introduce you to the tools you can use to investigate throttling, connection events and resources, and poorly performing queries such as dynamic management objects (DMVs and DMFs) and cloud-based tools in Microsoft Azure. You will also learn how to appropriately handle throttling in your applications and scale by partitioning databases.
Optimization is very hard topic which requires deep understanding of how underline system works. While every app is unique in its implementation, there are common areas that might improve app performance and memory usage in general. This especially true when apps were updated from previous versions on Windows. In this session, Mickey MacDonald talks about these common areas, how to optimize, and how to plan for low memory and hardware constraints.
Even though you're watching this on-demand, Mickey wants to help. Post your questions, comments, etc below or tweet it, mentioning @cdndevs.