BI Pros: Fix SQL Server Analysis Services (SSAS) Performance Problems

Struggling with SSAS and SSIS slowdowns?

SQL Server Analysis Services (SSAS) performance troubleshooting can be challenging. Data teams can struggle with identifying the true source of these kinds of performance problems. Sometimes the problems originate with the SQL Server Integration Services (SSIS) packages.

Design-related performance problems

Finding performance problems related to the database design can be a struggle, especially if you can't easily consult the team who created the data model.

SSAS restarting or crashing for unknown reasons

If you're seeing unfamiliar files in your SSAS logs folder, SSAS might be restarting, which could cause a processing or querying issue.

Slow reporting delaying data delivery

If SSAS slows to a crawl just when you need to deliver reports to stakeholders, your system might need to be optimized for high-concurrency workloads.

Finding SSAS performance problems is burning time

If your SSAS performance troubleshooting involves setting up traces or DMV queries, then you might be wasting time you could be spending on more strategic initiatives.

Your SSIS packages might be a source of performance problems

If you don't have a way to monitor SSIS packages to ensure that they're running as expected, you could be missing a key piece of the performance puzzle.

Struggling with SSAS slowdowns | SentryOne

How to Solve Your SSAS or SSIS Performance Problems

SentryOne empowers BI professionals to optimize performance of business-critical information. BI 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 BI Sentry Helps You Solve SSAS Performance Problems

Unparalleled insight into SSAS performance problems

SentryOne BI Sentry helps you see bottlenecks related to SSAS memory and storage systems, aggregation usage, and unoptimized queries.

Support for Multidimensional and Tabular modes

BI Sentry supports both Multidimensional and Tabular modes, including a Top Commands view that captures and aggregates all high-impact SSAS commands (MDX, DMX, DAX, and XMLA), and displays top commands by CPU and I/O usage.

Visibility into SSAS cache and disk activity

With BI 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.

The BI Sentry performance dashboard shows both Windows- and SSAS-specific metrics side by side for a complete view of data platform performance.

SentryOne BI xPress Provides Real-Time Monitoring for SSIS Packages

Ensure SSIS packages run as expected

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.

See real-time SSIS package execution data

The BI xPress monitoring console 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.

Customize details about SSIS packages

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.

The SSIS monitoring console in BI xPress helps you visualize the performance of SSIS packages so you can see where problems occurred and diagnose the problems.

Optimizing SQL Server Analysis Services (SSAS)

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

Optimize SSAS Tabular Performance | SentryOne Paper

"We needed knowledge and experience with alerting intelligence, and we got that with SentryOne."

—Nick Duckstein, Tableau Software

Customers with the highest demands for database performance choose SentryOne

Ready to fix your SSAS and SSIS performance problems?

"SentryOne is synonymous with '1 picture is worth a 1000 words.' It has the ability to give you at a glance all the necessary information related to databases, instances, networking and servers—both in live and historical views."

—Vasilis Papamichael, Database & Security Administrator, GAS Supply Company