Set up OLE DB source to read from View efficiently

  Introduction OLE DB source adapter is one of the most commonly used components in SSIS data flow task. In this article, we will discuss a very important performance observation about this adapter. Use “SQL Command” to pull data from a view OLE DB source adapter can be set up to work in either “SQL…

7

Getting Optimal Performance with Integration Services Lookups

Introduction Most users see good performance from SSIS packages using out-of-the-box configurations and with little tuning. Sometimes, though, it is necessary to do tuning to get optimal performance. One of the most commonly used transformations is the Lookup transformation. There are several techniques for getting optimal performance from a Lookup transform in SSIS. A few…

8

What’s so temporary about tempdb?

Other than #temptables, @localvariables and many other objects being stored in tempdb what’s so temporary about it?  TempDB is always present on each SQL Server instance and can be a determining factor of your overall performance.  In many ways tempdb could be named scratchdb or pagefiledb.  The following papers will help you understand what goes…

1

SQL Server 2005 SP2 Re-release and post fixes

Bob Ward from PSS has a wonderful blog article that explains the details about the re-release of SQL Server 2005 SP2 and fixes posted later. This is a must read for anyone deploying SQL Server 2005 SP2 to understand the various hotfixes, GDRs and procedures. Please visit his link for more details. SQL Server 2005…

0

Microbenchmarking

Microbenchmarking is the art of testing your machine’s basic configuration like disk latency, memory latency, CPU performance using series of tests. You can find more details at: Types of benchmarks How do you assess the performance of a new machine with SQL Server? Do you run industry standard benchmarks like TPCC and TPCH? If you…

1