BI xPress' Monitoring Console provides users with many of the same details and real time monitoring that would be provided to a user that were debugging a package within BIDS, Visual Studio, or SQL Server Data Tools. To open the Monitoring Console, either click the Monitoring Console button within the main "BI xPress" menu bar of BIDS, Visual Studio, or SQL Server Data Tools or launch it from the Pragmatic Workbench. After opening the Monitoring Console, you will be able to start real-time monitoring or view historical reports from the main screen.
The Monitoring console is divided into six main panels: Option Toolbar, Package Execution, Execution Diagram, Errors and Warnings, Variables, and Connection Panels. The Option Toolbar allows users to manage the BI xPress Database, as well as Monitoring Console behavior. The Package Execution panel allows a quick summary of the most recent executions as well as control over which execution is currently being displayed. The Execution Diagram shows a visual representation of both the control and data flow as well as further details. Besides the Package Execution and the Execution Diagram, there are three other, smaller, panels that provide details regarding the executions: error and warnings, variables, and connections panels.
1. Errors and Warnings: The errors and warnings panel provides details of all errors and warnings thrown by the currently selected package, making it easier to troubleshooting problem packages.
o Users can filter out the messages displayed within the Errors and Warnings panel to show either all messages, only errors, or only warnings.
2. Variables: The variables panel displays a time line of all changes to user variables within the currently selected package.
o If variable change tracking is enabled, users can switch between displaying the latest value for each variable, or view a historical list of all variable changes that took place during the execution of the currently selected package.
3. Connections: The connections panel provides details of all present connection managers within the currently selected package.