Permon counters on SQL 2005 mirroring (user defined counter log file is empty)

Question

I've been attempting to gather performance counters for mirroring using perfmon (user defined log files) saving this to a log file.

I create the log settings with Mirroring counters and click start and the counter runs without errors or problems. However, when Is top the counter and try to open the log file it is always empty.

I am able to do this without problem for general SQL Server counters but not for mirroring.

I have tried using perfmon on Windows Server 2003 and Windows Server 2008R2. This is for SQL 2005 Enterprise Edition. 

Is this a known issue? How can I resolve this? Thanks.

Answer 1

On mirroring server log files are on norecovery mode so its not accessable to capture any perfmon log counters - by the way want command are you using to capture the counters

---

http://uk.linkedin.com/in/ramjaddu

Answer 2

"On mirroring server log files are on norecovery mode so its not accessable to capture any perfmon log counters" That doesn't make sense, as specific mirroring counters are meant for the mirrored server. ie: Redo bytes/sec, Redo Queue, Bytes Received/sec. I am also not using a command, I am using Performance Monitor.

Answer 3

Does it happen only on this server? I have never had a problem collecting Mirroring performance counters.  You might have to open a CSS case

Thanks

Answer 4

If you collecting mirroring counters then their should be some problem... can you see any errors in windows event log file?

---

http://uk.linkedin.com/in/ramjaddu

Answer 5

Hi Dina_1818,

According to your description, I have tested the scenario on SQL Server 2005 Enterprise Edition with Windows 2008 R2. I create a Data Collector Set under User Defined menu, and then create the Data Collector by right clicking the new Data Collector Set. After that, I start the Data Collector Set. Meanwhile, I can see the performance counter file location by the Output field.

If that does not work for you, please have a look at Windows error log, and post here if there is any related information.

---

Stephanie Lv

TechNet Community Support

Answer 6

Could you Run this query and confirm if it returns some result:

select *
from sys.dm_os_performance_counters
where object_name like '%mirror%'

---

Fabrício França Lima | MCP, MCTS, MCITP | Visite meu site: http://fabriciolima.net | Dicas de artigos SQL: Siga-me no twitter @fabriciodba.