SQLTeam.com | Weblogs | Forums

Mirroring and Data Collector


#1

Hi,
on our test environnment (n. 2 SQL Server 2014 Standard Edition) we have activated the mirroring function (syncronous with manual failover) on 13-14 databases. Now, from Data Collector report, I can see an huge incrementation of some Wait Stats. In particular the top categories are: DBMIRROR_EVENTS_QUEUE, DBMIRRORING_CMD, BROKER_TASK_STOP.
Is this behaviour normal or is sympthom of something wrong?
Below the report (from Data Collector) after the implementation of mirroring functionality.


#2

Those 3 are ignorable waits: https://www.brentozar.com/responder/triage-wait-stats-in-sql-server/


#3

Hi Tara,
thanks for your reply. Do you know if is it possibile to exclude this waits from Data Collector? The problem is that (as you can see in the image) the Mirroring waits misrepresent all the others. Thanks


#4

I'm not aware of a way to do that. What I do instead is run a query to get the waits that has the exclusion list, such as the query that's in the link I provided.