DB Mirroring Performance Statistics

  • 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.

  • 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%')

  • Ok thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply