July 8, 2014 at 9:18 am
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.
July 9, 2014 at 1:25 am
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%')
July 9, 2014 at 2:48 am
Ok thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply