Wed, Mar 26 2014 12:00 Eastern Daylight Time
Query Performance Tuning for Azure SQL Database – sponsored by Dell Software
Just because you're using an Azure SQL Database doesn't mean you can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using lots of resources. Data movement out of the Azure storage costs money. Federating databases means queries run on multiple systems all at the same time.
This session will introduce you to the tools available for identifying poor performing queries, including dynamic management objects, query I/O, and others. You'll learn how to understand why a query is running slow using the Azure Database Portal. With this understanding, you’ll be able to fix your poorly performing queries. All in the cloud.
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
May 25: Noon Eastern
June 8: Noon Mountain
About the recording for September 23: You may want to advance
the video about 5 minutes into the file.
The DBA Virtual Chapter presentations are recorded. On the Meeting Archive page, you will find .WMV files that can be viewed on-line.
We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley, firstname.lastname@example.org.
The DBA Virtual Chapter holds two webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.