SentryOne empowers BI professionals to optimize performance of business-critical information. SQL Sentry helps you find and fix performance problems with SQL Server Analysis Services (SSAS). BI xPress provides visual monitoring and an auditing framework for SSIS packages.
SentryOne SQL Sentry helps you see bottlenecks related to SSAS memory and storage systems, aggregation usage, and unoptimized queries.
SQL Sentry supports both Multidimensional and Tabular modes, including a Top
With SQL Sentry, you can identify data and log files quickly and visualize how data is flowing through your disk system. You can also see SSAS internal cache activity as well as disk activity.
SentryOne BI xPress gives you the ability to seamlessly audit, manage, and monitor SSIS packages. You can easily visualize the state of your packages, determine where and why issues occurred, and get detailed information about their performance.
The BI xPress displays data from the execution of your SSIS packages, including performance information and execution trend data. You can monitor multiple servers and packages with one interface. The console's visual display helps you see package failures and quickly diagnose performance problems.
You can use the Auditing Framework Wizard in BI xPress to add or remove instrumentation in your packages so you can customize the amount of detail you see in the console.
Download our free 5-part eBook
Troubleshooting performance problems with SQL Server Analysis Services (SSAS) can be a frustrating exercise. Dive into this five-part guide by Steven Wright, Product Manager at SentryOne to learn time-saving tips for boosting SSAS performance. The book covers:
1. Understanding SSAS basic MOLAP architecture
2. Identifying impacts on MDX query performance
3. Improving MDX query performance
4. Tracking trace events
5. Troubleshooting bottlenecks