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, 223 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, 719 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, 733 reads
Posted in Devin Knight on 1 July 2010