Establishing a performance monitor session

In this recipe, you are going to prepare an ad-hoc performance monitoring session by using the Performance Monitor, a component of the Windows operating system.

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

6. Click Add >> below the list. The counters should now be listed in the Added counters list on...