Everyone of us knows that it is bad, but we are still doing it: using SQL Server Profiler! But SQL Server Profiler is since SQL Server 2016 a deprecated feature and will be removed in a future SQL Server version. Therefore it is very important that you get a basic understanding about the replacement technology called Extended Events.
Extended Events were first introduced with SQL Server 2008 and they provide you a lightweight tracing infrastructure in SQL Server, which is much more powerful than SQL Server Profiler ever was. During this 6 hour long online seminar you will get a basic understanding about Extended Events and how you can use it in your day-to-day live as a database developer and database administrator to troubleshoot specific SQL Server problems.
In this 6 hour long online training you will learn about:
- Introduction to Extended Events
- Event Targets
- Event Counter Target
- Ring Buffer Target
- Event File Target
- Histogram Target
- Pair Matching Target
- Event Sessions
- Event Flow
- Event Options
- DMVs
- Analyzing Data with XQuery
- Troubleshooting Scenarios
- Sort & Hash Warnings
- Wait Statistics
- Page Splits
- Timeouts
- Spinlock Contention
