17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

Query Tuning in the Clouds

Just because you're using an Azure SQL database does not mean you can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using up lots of resources. This session will introduce you to the tools you have available to identify poor performing queries, such as dynamic management objects and others. You'll learn how to understand why a query is running slow using the Azure Portal execution plans. This understanding will enable you to fix your poorly performing queries.  All in the cloud.
Presented by Grant Fritchey at SQLBits XI
Tags (no tags)
  • Downloads
  • SpeakerBIO
    Grant_Fritchey.jpg
    Grant Fritchey, SQL Server MVP, works for Red Gate Software as Product Evangelist. In his time as a DBA and developer, he has worked at three failed dot–coms, a major consulting company, a global bank and an international insurance & engineering company. Grant volunteers for the Professional Association of SQL Server Users (PASS). He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server 2008 Query Performance Tuning Distilled (Apress). He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG). He earned the nickname “The Scary DBA.” He even has an official name plate, and displays it proudly.
    http://scarydba.com http://scarydba.com/feed
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.