Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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).

share|improve this question

closed as off-topic by Max Vernon, Paul White, RolandoMySQLDBA, bluefeet, Jon Seigel Oct 2 '13 at 23:39

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, Paul White, RolandoMySQLDBA, bluefeet, Jon Seigel
If this question can be reworded to fit the rules in the help center, please edit the question.

If I try sys.dm_os_performance_counters as a workaround - how do I go about gathering the performance data over a period of 1 day? –  Dina Feb 15 '12 at 16:43