I've been attempting to gather performance counters for mirroring using perfmon, over a period of time and saving this to a log file. I am able to do this without problem for general SQL Server counters (Using this tutorial by Brent Ozar: http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning) but for mirroring my log file is always corrupted and opens in perfmon showing nothing. I have tried using perfmon on Windows Server 2003 and Windows Server 2008R2 but both error out. I get an error sometimes that says: a binary counter had less than two values.
Has anybody run across this issue? There are many mirroring counters, and so don't know which of them is causing the problem). (Note: collecting mirroring info on SQL2005 Enterprise - principal server).
