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 SQL Server 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. He joined Red Gate Software as a product evangelist in January 2011.
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.
August 13 Noon Mountain Warner Chaves Best Practices for your
Very Large Databases
August 27 Noon Eastern Keith Tate The Curious Case of Isolation Levels
The DBA Virtual Chapter holds two webinars on the second Wednesday of every month at noon, Mountain time and on the fourth Wednesday of every month 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.
We thank our sponsor