The most recent content from our members.
SQL Sentry comes preconfigured with well over a hundred alerting conditions for failures, offline servers, long running queries, and more. You may also be aware of SentryOne’s Advisory Conditions. This advanced alerting and response system allows you to truly customize the product to respond to any condition with complex…
Previously, I revealed a problem one of our customers encountered when SSAS memory limits were inadvertently set to KB instead of bytes, leading to abnormally low limits and some pretty serious performance issues. I alluded to a “saving grace” that prevented things from being much worse than they actually were, and that’s…
Previously, I introduced SQL Sentry’s latest round of enhancements for monitoring SSAS Tabular mode. In this post, I’ll dig a little deeper into what you can learn about SSAS in Tabular mode from the enhancements to the SQL Sentry Dashboard. To start, let’s cover some basic behaviors of VertiPaq as seen in the xVelocity…
If you are familiar with SQL Sentry and SentryOne’s community experts, you might have seen many of our resources focused on tuning and troubleshooting SQL queries. But did you also know that SQL Sentry supports SQL Server Analysis Services (SSAS) performance monitoring? We have supported in-depth, comprehensive monitoring…
Almost nine years ago I started writing a blog series about SQL Server Analysis Services (SSAS) performance. Our monitoring support for SSAS had been released a couple years prior, and as our lead Solutions Engineer, I found myself answering a lot of the same questions and helping people effectively interpret and act upon…
Hi, Just starting with SQL Sentry. I'm using it with an SSAS Tabular instance. I'm interested in diving into the commands we capture, but find it challenging to go about that. I think something like a Power BI content pack focusing on commands (or SQL queries) would be great. I'm not necessarily trying to review all…
Hi guys, * SQL Server Analysis Services use is on the upswing: At Coles Supermarkets we have a lot of SQL Server Analysis Services (SSAS) users and it is growing with the trend towards data analysis and marketing. * Growth in use means performance issues: It's not an area all of our DBAs are familiar with. We usually set…
Hi guys, For those of you who support an companies or client(s) that uses SQL Server Analysis Services (SSAS) and would like to monitor and improve the performance of SSAS, I've opened a Feature Request for Solarwinds to provide this additional monitoring either as a plugin or licenced product. If you feel this would…
Can you please advise if anything we can monitor for SSAS (SQL Analysis Services) in Ignite (DPA) , we are interested to capture below details for SSAS Server. SSAS Instance level monitoring: Service state Memory Configuration Conflict with SQL Server TotalMemoryLimit Configuration Memory Usage Memory Usage on the Server…
It looks like you're new here. Sign in or register to get started.