ApexSQL BI Monitor

ApexSQL BI Monitor

BI performance monitoring (SSAS/SSIS/SSRS)

Monitor and detect SQL Server analysis, integration and reporting services performance issues

Besides being able to monitor Microsoft SQL Servers with ApexSQL Monitor and virtual environments with ApexSQL VM Monitor, you will soon be able to monitor all Microsoft SQL Server services, including analysis services, reporting services and integration services.

ApexSQL BI Monitor will be a web application, with a familiar ApexSQL Monitor web interface, that monitors system, analysis, reporting and integration services’ performance in real time. We’ve curated a set of more than 100 performance counters that will be included in the first release.

Overview

• Monitor SSAS, SSIS and SSRS performance
• Add custom performance counters
• Track system performance
• Use baselines to customize alert thresholds
• View real-time and historical data
• Set up various alert actions for each counter
• Generate built-in and custom reports
• Track user activity

  Additionalfeatures Other than monitoring features, ApexSQLBI Monitor will include many other features, such as alerting, metric history,custom metrics, reporting and many more useful qualities that can help you keepyour finger to the pulse of all of your BI sub-systems.               Features       Cube and SSASobjects performance Monitor performance of multidimensionaldatabases, cubes and other SSAS objects such as mining structures anddimensions. Track the CPU time consumed by objects or databases, the number ofhits and misses and other performance counters                 Combinepredefined metrics Combine two metricsto be able to monitor their ratio and get notified when the ratio exceeds adefined threshold                 Comprehensivedashboard Check the state of all monitoredservices including reporting, analysis and integration services via a groupdashboard using either panel or table views                 Service overview Review reporting, analysis andintegration service information and health by category and easily detectperformance issues. Drill down for more details about every problematic counter                 Systemperformance monitoring Track possible underlying systemperformance issues that might lower the performance of SQL Server services                 Baselines Calculate and configure baselines foreach counter to raise alerts                 Alerting andalert actions Get notified whenever a counter exceedsits configurable threshold and create alert actions which will execute SQLscripts, shell commands, and/or send e-mail notifications when an alert israised                 Configuration Control the entire monitoring andalerting process. Disable and enable monitoring and alerting per counter,create maintenance periods and maintenance periods' schedules, include andexclude system devices, set up a different threshold for each system device andmany more                 Reporting Generate built-in reports or createcustom reports based on your preferences                   Custom counters Easily create and configure new countersto extend the capabilities of a built-in counter set                 User security Increase monitoring security andreliability by creating users with different roles                 Activity log Track the actions that have beenexecuted within the application along with their status and other details