O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

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

How to do it...

  1. In the Windows Start menu, locate the Performance Monitor and open it.
  2. In the tree on the left, expand the Monitoring Tools node, and select the Performance Monitor node.
  3. In the command ribbon on the right side of the window, click the Add icon, marked by the green plus sign, to open the Add Counters dialog.
  4. In the Available counters list, locate the SQL Server SSIS Pipeline 13.0 group, and expand it by clicking the tiny downward arrow to the right of the group name.
  5. With the help of the ctrl button on your keyboard, and the mouse, select the following counters:
    • Buffer memory
    • Buffers in use
    • Buffers spooled
    • Flat buffer memory
    • Flat buffers in use
    • Private buffer memory
    • Private buffers in use
  1. Click Add >> below the list. ...

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