Event handlers are a great tool for managing errors and other events that occur during the execution of a package run. Using event handlers can however add additional time to the run of a package. Depending on the event that is selected it could cause more performance issues than others. For example, if you have the OnInformation event selected then the package could fire off the event dozens of times during one run, but when you have the OnError event selected you will only see the event fire o...
Read More
There are several techniques that can be used for performance tuning Analysis Services. You may already be familiar with the typical methods used like Partitions and Aggregations . However, an often forgotten method for tuning query performance is cache warming. This is the very basic idea of running your frequently used queries ahead of time so that after reprocessing your cube your users will not be querying from a “cold cache”. The queries that your users will run throughout the day will alre...