Systems Engineering and RDBMS

SSIS Perfmon Counters

Posted by decipherinfosys on March 7, 2008

We have covered specific perfmon counters before and have also covered how to co-relate the perfmon counters with the profiler traces in SQL Server 2005. In today’s post, we want to mention another set of counters that are at our disposal for looking into performance issues of SQL Server Integration Services (SSIS). As you can see from the image below, there are quite a few perfmon counters at your disposal.

ssis_perfmon_1.jpg

Some of the key ones are:

  • Buffers in use
  • Buffers spooled
  • Rows read
  • Rows written

You can get the explanation of those from perfmon itself by hitting explain. You can use “Buffers in use” to help you identify any memory leaks that you have in your packages…you should compare the values for these before the package execution and after the execution. The numbers should be the same – if not, then you have a buffer leak issue. Rows read and Rows written will give you information about the execution progress of the data flow. Buffers spooled starts off with a value of 0 and if it goes above that value, then it means that memory swapping is going on.

Sorry, the comment form is closed at this time.

 
%d bloggers like this: