SQL Server Performance Tuning and Optimization

SQT04 U-SQL Query Execution and Performance Tuning

12/06/2016

11:00am - 12:15pm

Level: Advanced

Michael Rys

Principal Program Manager

Microsoft

When processing TB and PB of data, running your Big Data queries at scale and performing at peak is essential. This session will discuss the tools and practices to monitor, tune and improve U-SQL script performance. If you really want to know U-SQL in depth, this session should be your ultimate destination. Be prepared to go in-depth into the aspects relating to query execution and optimization and best practices.

You will learn:

  • How to analyze a U-SQL Script for performance
  • How to use U-SQL partitioning and distribution schemes to optimize
  • Best practices in writing performing U-SQL scripts