Sunday, March 25, 2012

Can't find SQL Server: SSIS Pipeline performance object in perfmon for 64-bit Server

I can't find 'SQL Server: SSIS Pipeline' performance object in performance monitor on a 64-bit SQL Server. I see it on a 32-bit. Does anybody know why?

Thanks

The 'SQL Server: SSIS Pipeline' performance objects in perfmon don't work in x64. They simply don't appear when viewed from either an x64 machine or a x86 machine.

However, if you login to the x64 machine locally and use the 32 bit version of perfmon (C\WINDOWS\SysWOW64\perfmon.exe), you can see them, but even that workaround is not very useful when you have a significant number of SSIS machines you'd like monitored.

No comments:

Post a Comment