…brew your own Business Intelligence

Posts Tagged ‘Troubleshooting’

Choosing the Right Instance in Perfmon

There’s been quite a bit posted on this blog regarding the collection of perfmon counters to monitor Analysis Services instances and troubleshoot performance problems. And some of the recommended perform counters (e.g. Process: % Processor Time) are “instance”-specific… meaning you need to select the name of the process for which […]

Read more

Troubleshooting #SSAS Performance Issues

For the past 2 years, I’ve spent quite a bit of time across several clients addressing performance issues with Analysis Services solutions. Now that may sound like your own personal hell, and I totally understand why. Analysis Services is complicated enough just to get it off the ground and into production. […]

Read more

Automating SSAS Dump Collections using SQLDumper.exe

Last year I was involved with standing up an Analysis Services Scale-Out Query Server architecture to handle a heavy concurrent user load. Unfortunately, we didn’t get around to stress-testing the system until a few months later and we uncovered an issue requiring escalation to Microsoft. In this post, I’ll share a […]

Read more

SSIS Data Viewer Objects are Static

Recently, while debugging the logic involving a derived column component in an SSIS data flow, I learned something new and thought I’d share 🙂 Before we dive into the details, let’s quickly review a few of the common methods for troubleshooting issues in an SSIS data flow: using error output […]

Read more