Your users are frustrated because the app is too slow, and you can change the SQL queries – but how? Which ones? Where do you start? And how can you make them 10x or 100x faster?
Take heart – there’s hope. Microsoft Certified Master Brent Ozar will show you how to identify which queries use the most resources on your SQL Server, measure those queries, identify common anti-patterns, and tweak or rewrite the queries to achieve faster performance.
You should already be comfortable writing T-SQL, getting execution plans (although maybe not reading them). To get the most out of this class, we strongly recommend watching Brent’s free online class, How to Think Like the Engine. That’ll explain clustered vs nonclustered indexes, seeks, scans, and sargability in 90 minutes so you’ll be up to speed with the terms Brent uses in class.
- Find Your Worst Queries with sp_BlitzCache
- How to Measure One Query’s Performance
- Discover and Troubleshoot Parameter Sniffing
- Why Functions Don’t Scale, and How to Rewrite ‘Em
- Fixing Cardinality Estimation Problems
- Watch Brent Tune Queries 2017
Houston – this is a SQLSaturday Houston pre-con on Friday, June 16th, 2017 at Atlantic Plant Maintenance Training, 3225 Pasadena Blvd, Pasadena, TX 77503. Doors open at 7:30AM, be in your seat for an 8AM start, and we’ll be out by 4:45PM. After you register for this class, make sure to register for SQLSaturday Houston too – it’s a totally free day of training from volunteer presenters. (Note that SQLSaturday Houston is at a different location – San Jacinto College South.)
Logistics – Lunch is included in your registration fee. You’ll get a link to download the slide PDFs ahead of time, but to keep costs down, we won’t have printed handouts. You’re welcome to bring a laptop if you want to follow along with the demos (you totally don’t have to), but power & WiFi isn’t guaranteed. (We usually get 100+ folks at these kinds of community events, and that many of us geeks can knock out a building’s WiFi, hahaha.)