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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:06 AM
Points: 53, Visits: 159
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: Monday, October 6, 2014 4:51 AM
Points: 1,204, Visits: 576
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:06 AM
Points: 53, Visits: 159
Ok thanks.
Post #1590641
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse