Webcast : SQL Server Query Tuning
About this webcast:
In this session you will learn the basics of how to tune queries in a SQL Server environment, through a demo-heavy and technique focused session.
You will learn how to read an execution plan, and gain knowledge of techniques to improve query performance and throughput.
Attend this webcast to learn how to optimize your development efforts.
Joseph D’Antoni is an Senior Architect and SQL Server MVP with over a decade of experience working in both Fortune 500 and smaller firms. He is currently Principal Consultant at Denny Cherry and Associates in Malvern, PA. He is frequent speaker at major tech events, and blogger about all topics technology. He believes that no single platform is the answer to all technology problems. He holds a BS in Computer Information Systems from Louisiana Tech and an MBA from North Carolina State.
- Granular wait state monitoring
- Continuous SQL sampling
- Intuitive drill down to view top activity
- Query plan tuning and recommendations
- Lock and latch resolutions
- Storage visibility and contention resolution