Thursday, March 08, 2012 8:00 PM
Thursday, March 08, 2012 8:10 PMOn 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
Thursday, March 08, 2012 9:15 PM
"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.
Friday, March 09, 2012 1:53 AM
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
Friday, March 09, 2012 9:42 AMIf you collecting mirroring counters then their should be some problem... can you see any errors in windows event log file?
Monday, March 12, 2012 7:03 AMModerator
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.
TechNet Community Support
- Marked As Answer by Stephanie LvModerator Monday, March 19, 2012 8:22 AM
Wednesday, March 14, 2012 2:21 PM
Could you Run this query and confirm if it returns some result:
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.