Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DB Mirroring Performance Statistics Expand / Collapse
Author
Message
Posted Tuesday, July 8, 2014 9:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:56 AM
Points: 46, Visits: 132
Hi,

I am trying to find some performance statistics for database mirroring which I have set up on my SQL Server instance.

I have looked in the 'sys.database_mirroring' table but can't find anything in there.

I am looking for things like for example - Database Mirroring Transactions per second, Size of transactions going from Principal to Mirror etc. or any other useful statistics I can access for database mirroring.

Where can I find statistics like these for mirrored databases?

What performance statistics are available for database mirroring?

Any help much appreciated. Thanks.

Post #1590411
Posted Wednesday, July 9, 2014 1:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:07 AM
Points: 1,183, Visits: 572
You can use "Launch Database Mirroring Monitoring" from SSMS by right clicking on database->Tasks.

Also the following query will provide the performance counters:
select * from sys.dm_os_performance_counters WHERE [object_name] LIKE ('%Database Mirroring%')
Post #1590628
Posted Wednesday, July 9, 2014 2:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:56 AM
Points: 46, Visits: 132
Ok thanks.
Post #1590641
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse