Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2009-03-17 : 08:40:43
|
| I need to understand how my package runs regarding performance. I hve read that certain counters to collect are Buffers SPooled, number of buffers in use, etc.However, where are these counters? I've looked in Perfmon, and I can't find anything that is SSIS specific? What/where should I be looking?ThanksHearty head pats |
|
|
cdepaolo
Starting Member
2 Posts |
Posted - 2009-03-17 : 14:52:23
|
| In Perfmon, either click the Objects button to get to SQLServer SSIS: Service and SQLServer SSIS: Pipeline objects or click the counters button and scroll through Performance Objects until you reach the desired object and select the counters you are interested in analyzing. |
 |
|
|
|
|
|
Using perfmon to collect SSIS perf counters