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, July 22, 2014 3:04 AM
Points: 43, Visits: 122
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 @ 7:00 AM
Points: 1,166, Visits: 566
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, July 22, 2014 3:04 AM
Points: 43, Visits: 122
Ok thanks.
Post #1590641
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse