| 1 | What are Extended Events, and why are they generally recommended over SQL Server Profiler for modern monitoring needs? SQL Server › SQL Server Profiler & Extended Events | SQL Server | SQL Server Profiler & Extended Events | Beginner |
| 2 | How do you create an Extended Events session to capture specific long running queries on a production server? SQL Server › SQL Server Profiler & Extended Events | SQL Server | SQL Server Profiler & Extended Events | Intermediate |
| 3 | How do you analyze the data captured by an Extended Events session once it has been running for a period of time? SQL Server › SQL Server Profiler & Extended Events | SQL Server | SQL Server Profiler & Extended Events | Intermediate |
| 4 | How do you properly stop and clean up an Extended Events session once it is no longer needed? SQL Server › SQL Server Profiler & Extended Events | SQL Server | SQL Server Profiler & Extended Events | Intermediate |
| 5 | How would you design an Extended Events session to monitor for a very specific, hard to reproduce issue, such as intermittent deadlocks, in a production environment? SQL Server › SQL Server Profiler & Extended Events | SQL Server | SQL Server Profiler & Extended Events | Advanced |
| 6 | What is the performance overhead comparison between SQL Server Profiler, server side traces, and Extended Events, and how should this inform monitoring decisions on a production system? SQL Server › SQL Server Profiler & Extended Events | SQL Server | SQL Server Profiler & Extended Events | Advanced |
| 7 | What is SQL Server Profiler, and what is it traditionally used for? SQL Server › SQL Server Profiler & Extended Events | SQL Server | SQL Server Profiler & Extended Events | Beginner |
| 8 | What error information functions are available inside a CATCH block to help you understand what went wrong? SQL Server › Error Handling with TRY CATCH | SQL Server | Error Handling with TRY CATCH | Beginner |
| 9 | What is Query Store in SQL Server, and what information does it automatically capture? SQL Server › Query Store | SQL Server | Query Store | Beginner |
| 10 | How do you view the top resource consuming queries captured by Query Store? SQL Server › Query Store | SQL Server | Query Store | Beginner |