SQL Server MVP và tất cả các xung quanh chàng trai thông minh, Jonathan Kehayias, đã phát triển''Manager mở rộng sự kiện,''một giao diện người dùng để mở rộng sự kiện mà bạn có thể tải về từ .com / ExtendedEventManager. Jonathan cũng viết một tờ giấy trắng trên sự kiện mở rộng cho Microsoft. Có đọc một bản dự thảo, nếu bạn quan tâm trong việc thực hiện một sự kiện mở rộng giải pháp, tôi khuyên bạn nên nó. Xem cho một liên kết | Part VIII Monitoring and Auditing SQL Server MVP and all-around smart guy Jonathan Kehayias has developed Extended Events Manager a UI for Extended Events that you can download from .com ExtendedEventManager. Jonathan is also writing a white paper on Extended Events for Microsoft. Having read a draft if you re interested in implementing an Extended Events solution I highly recommend it. See for a link. Packages At the top level Extended Events organizes its components into three Microsoft-developed packages it s really four but the fourth package SecAudit is a private package dedicated to SQL Audit Package0 Provides base functionality used by the other packages sqlo s Works with the SQL OS events sqlserve r Works with the rest of SQL Server Each of these packages contains several objects. To see the full list of objects within packages query the following DMVs SELECT AS Package AS Object FROM o JOIN p ON ORDER BY Result abbreviated Package object_type Object description package0 action tsql_stack Collect Transact-SQL stack package0 action sql_text Collect SQL text package0 action plan_handle Collect plan handle package0 action create_dump_single_thread Create mini dump for current thread the package0 action create_dump_all_threads Create mini dump including all threads The object_type column reveals seven types of objects actions events maps pred_compares pred_sources targets and types. Building a crosstab query from the previous query analyzes the distribution of object types within the packages SELECT Package action event map pred_compare pred_source target type FROM SELECT AS Object AS Package FROM o JOIN p 1262 Extended Events 58 ON sq PIVOT COUNT Object FOR object_type IN action event map
