sqldmj

  • Comprehensive monitoring of SSAS, SSRS, & SSIS health
  • See detailed SSAS performance metrics, query activity, and sessions
  • Identify issues with object utilization in both Cube and Tabular models
  • Monitor both user and report activity in SSRS
  • View SSIS package execution details and history

Comprehensive Monitoring of the SQL Server BI Stack
Monitor the health and availability of your entire SQL Server BI environment including SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS). Ensure uptime and identify issues quickly.
Detailed SSAS Performance Metrics
Monitor a wealth of SSAS performance and processing metrics, query activity, cache, sessions, object utilization, and user activity - everything you need and more to keep your analysis services running at peak efficiency.
Tune Object Utilization for Cube and Tabular Models
See the performance of your analysis models as well as your analysis servers. Monitor formula and storage engine cache, memory utilization, and row activity for objects to help you tune both cube and tabular models.
Monitor Reporting Services and Integration Packages
View SSRS performance counters and report execution activity to monitor how long it takes for reports to run, which ones didn’t run, and the impact on server resources. View by user, by session, and by processing time. See SSIS activity to monitor integration package status, execution duration, and if there were errors.
Configurable Alerts
Set alerts and email notifications with configurable threshold levels to keep you informed of only the relevant information.
Web-based Dashboard
Log in from anywhere and quickly check the status of monitored SQL BI server instances. The customizable web dashboard provides at-a-glance status of top issues and alerts with easy drill down capabilities so you can identify and diagnose issues quickly.

Performance Monitoring

SQL Server Analysis Services Monitoring
Get comprehensive monitoring of SQL Server Analysis Services and the servers they reside on. Server metrics include disk, network, cache, CPU, and memory. SSAS performance metrics include processing, query activity, memory, cache, sessions, object utilization, and user activity. Both Multidimensional (MOLAP, Cubes) and Tabular models.
SQL Server Reporting Services Monitoring
Monitor SQL Server Reporting Services and the servers they reside on including OS counters, SSRS Report Server counters, SSRS Web Server counters, and SSRS Windows Service counters. Monitor report execution metrics and track status, view processing time, and see report activity by user.
SQL Server Integration Services Monitoring
Monitor SQL Server Integration Services and the server they reside on including OS counters and performance counters. View SSIS package execution activity including drill down at the task level to track status and view error details.
Alerts & Notifications
Configure critical and warning threshold alerts for over 100 BI service metrics. View color-coded indicators on the dashboard, and receive email notifications to stay on top of potential performance problems.

Enterprise Management

Agentless Monitoring
SQL BI Manager does not install anything on your production BI servers. This simplifies installation and keeps the overhead on the monitored servers low. No need to install anything on your SQL Server
Web-based Dashboard
Log in from anywhere and quickly check the status of monitored SQL BI server instances. The customizable web dashboard provides at-a-glance status of top issues and alerts with easy drill down capabilities so you can identify and diagnose issues quickly.
Collaborate and Share
Export data from each view to send to management or share and collaborate with team members.
Secure
Easily give and restrict access to the applications based on a user’s role in the organization with role-based security.

dataapps