Main Profile

At A Glance

SQL - Identifying & Fixing Performance Problems using Execution Plans

View the full video here - http://tinyurl.com/pragwrks69 This session will demonstrate how SQL Server execution plans can be used to identify problems with the database design, or the TSQL code, and address those problems. The session takes the user through various common issues such as poor or missing indexes, badly written code and generally bad query performance, demonstrating how to identify the issues involved using execution plans. The session will then demonstrate different methods for addressing the issues and show how the fixed query's execution plans differ. Multiple methods for accessing execution plans including graphical, DMV's, and trace events are demonstrated. All this is meant to lay a foundation for a general troubleshooting approach to empower the attendee to make their own queries run faster and more consistently. Free training every Tues and Thurs - http://pragmaticworks.com/Resources/webinars/Default.aspx
Length: 08:06

Contact

Questions about SQL - Identifying & Fixing Performance Problems using Execution Plans

Want more info about SQL - Identifying & Fixing Performance Problems using Execution Plans? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question