O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with performance counters

Windows Performance Counter enables us to monitor in real-time multiple items that can measure the performance of the Data Flow engine. For example, you can watch the "Buffers spooled" counter to determine whether data buffers are being written to disk temporarily while a package is running. This swapping reduces performance and indicates that the computer has insufficient memory.

The performance counters are as follows:

  • BLOB bytes read: The number of bytes of binary large object (BLOB) data that the Data Flow engine has read from all sources.
  • BLOB bytes written: The number of bytes of BLOB data that the Data Flow engine has written to all destinations.
  • BLOB files in use: The number of BLOB files that the Data Flow ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required