Project Description
SQL 2008 Extended Events are a powerful new way of troubleshooting problems with SQL Server. One short coming is that there is no UI support for this new feature. The Extended Events Manager is a C# .NET winforms application that aims to simplify creating and viewing metadata for Extended Events Sessions in SQL 2008.
This project was initially published on the MSDN Code Gallery:
http://code.msdn.microsoft.com/ExtendedEventManager/
Planned Functionality:
- View Extended Events Metadata for all Available Objects
- View Event Sessions on a Server
- Start/Stop Events Sessions
- Create new Event Sessions
- Alter existing Event Sessions
- Drop Event Session
- Script all operations
- View information stored in targets for active Event Sessions
After a multi-month effort to rework the code base for the Library to correct a number of short comings in the first design the most recent stable build 1.0.3.115 is now available with a new Library that was first available in the 1.0.2.102 Alpha release. See the Details of the 1.0.3.115 build for more information on the changes made to the Library. This latest release also has significant UI changes that are also documented in the Release table for 1.0.3.115. These include a switch from a native MDI form layout to a Dock Panel SSMS like UI.
SQL Server 2008 Extended Events Manager Coming Features List:
- Configurable UI options that add flexibility to the application.
- Ability to set Defaults to override the Library Event Session Options Defaults.
- Provide options for Warnings on certain Events like Dropping an Active Event Session.
- Auto-Updating TargetDataViewer that updates the GridView datasource as events are buffered into the active target being viewed.
- Using SqlDependency Watcher to only populate new events.
- Add Predicate value and Target Option value validation to ensure that input values are compatible by datatype with the objects value datatype.
- Conversion of UI to WPF
- Use ObservableCollections to automatically reflect dataset changes through XAML.
- Convert GridViews to function closer to SSMS PBM Condition Grid.
SQL Server 2008 Extended Events Manager Current Bug List:
No currently known bugs exist. If you happen upon a bug, please log it in the Issue Tracker for this Project. All future bugs will be tracked through this tool only.
If you have a request for a feature, please open a discussion or a Issue in the Issue Tracker so that the request can be considered for inclusion in the project. A number of the most recent changes have been based on feedback that has been received from people regarding the tool and how it could be better. Many thanks go out to Adam Machanic for all of his recommendations and beta testing, without which the current state of the application would not exist.