Most of the time, your SQL Server queries are fine – but every now and then, things just tank. You swear nothing has changed, and things get magically better after a reboot.
What’s really going on?
In a day of demo-filled explanations, Brent Ozar will show you the three most common culprits: parameter sniffing, lock escalation, and inaccurate memory grants. You’ll learn what causes them, get free scripts to recognize them when they strike, discover how to stop the emergency, and then understand how to fix them long term.
This one-day session is for developers and database administrators who are comfortable writing queries, but kinda uncomfortable reading execution plans. To get the most out of this session, watch the free online class How to Think Like the Engine first to understand the basics of reading plans – and we’ll build atop that knowledge in the class.
Boston – Monday, June 26, 2017 9AM-5PM at Wayfair, 4 Copley Pl, Boston, MA 02116. Due to building security, attendees must be registered, and must present a valid photo ID to building security.
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 a bunch of folks at these kinds of community events, and that many of us geeks can knock out a building’s WiFi, hahaha.)