In this session, we’ll explore four critical Extended Events sessions that every SQL Server DBA should implement across all environments. From visualizing for the first time, capturing elusive application errors, to monitoring unauthorized changes and troubleshooting deadlocks. This webinar demonstrates how Extended Events provide lightweight, real-time insights to strengthen your server monitoring strategy.
Session Highlights
- Application Errors:
You will be shocked to see just how many Applications Ignore errors. From Ignored Primary Key violations, to permission issues, missing objects, or just plain bad syntax, this Extended Events also helps capture hard-to-diagnose application-side issues directly from the database engine, reducing reliance on guesswork or external logs.
- DDL Changes:
Track all schema changes in real time to enforce SOX compliance, governance, and prevent unauthorized modifications. Every business has those moments where, if something goes wrong, the first question is "what changed", and this gets you the "whodunnit" information.
- Login Tracking:
Tracking which accounts are in use from which host can help you audit what accounts are deprecated, as well as what accounts are used from your various App Servers
- Deadlocks:
Identify and resolve deadlocks quickly with minimal overhead, improving transaction reliability and performance.
