Subscribe to this blog
Devin Knight
Archives: July 2010
SSIS - Event Handler Performance
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. Read more
0 comments, 232 reads
Posted in Devin Knight on 20 July 2010
SSIS - Event Handler Performance
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… Read more
0 comments, 738 reads
Posted in Devin Knight on 19 July 2010
SSAS Cache Warming with an SSIS package
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… Read more
0 comments, 753 reads
Posted in Devin Knight on 1 July 2010