Your users are frustrated because the app is too slow, but you can’t change the queries. Maybe it’s a third party app, or maybe you’re using generated code, or maybe you’re just not allowed to change it. Take heart – there’s still hope. Brent Ozar does this every week, and he’ll share his proven methodologies to find the bottleneck with wait types, figure out if you can throw hardware at it, or if you’ll need to change SQL Server settings.
This course is currently in production. You can sign up to be notified when it’s available to purchase, or if you’d like to watch it now, buy The Everything Bundle. Our Everything Bundle folks get early access to courses while they’re still being edited and finished.
Currently available modules include:
How to Measure and Change Your SQL Server:
- 3 Metrics to Gather (23 minutes)
- Monitoring Tools (8m)
- SQL Server’s Parts Catalog (7m)
- How to Build Fast SQL Servers (30m)
- Server Hardware Sizing (22m)
Fixing Common Hardware-ish Wait Types:
- ASYNC_NETWORK_IOI (7m)
- CXPACKET (25m)
- PAGEIOLATCH (15m)