hat
Siveyans metriz pèfòmans bay yon bon fason pou evalye pèfòmans an jeneral nan yon solisyon baz done. Sepandan, gen okazyon lè ou bezwen fè analiz pi detaye nan aktivite ki rive nan yon Microsoft SQL sèvè egzanp-nan rézoudr pwoblèm epi idantifye fason yo optimize pèfòmans travay. SQL sèvè pwolonje Evènman se yon fleksib, ki lejè evènman-manyen sistèm bati nan Microsoft SQL sèvè Database Engine la. Modil sa a konsantre sou konsèp achitekti yo, estrateji depanaj yo ak senaryo l 'nan Evènman ki pi long. Leson
eng
Monitoring performance metrics provides a great way to assess the overall performance of a database solution. However, there are occasions when you need to perform more detailed analysis of the activity occurring within a Microsoft SQL Server instance—to troubleshoot problems and identify ways to optimize workload performance. SQL Server Extended Events is a flexible, lightweight event-handling system built into the Microsoft SQL Server Database Engine. This module focuses on the architectural concepts, troubleshooting strategies and usage scenarios of Extended Events. Lessons