Hi,

Within the current view for HADR within SQL PI, you have done a great job for exposing the Max Estimated Recovery Time (sec) and Max Estimated Data Loss (sec).

Is it possible to publish more metrics without causing impact?

It was recently announced by the MSSQL Tiger Team at Microsoft that SQL Server 2012 SP3 has exposed new counters and extended events to give further insight and it will be great if you can add them into future editions of the product?

For Reference, please find some further information you may find useful.


The performance counters are the folowing:

Group Commit Time
Group Commits/Sec
Log Bytes Compressed/sec
Log Compressions/sec
Database Flow Control Delay
Database Flow Controls/sec
Encryption I/Os/sec
Encrypted I/O bytes/sec
Redones/sec
Log Bytes Decompressed/sec
Log Decompressions/sec
Decryption I/Os/sec
Decrypted I/O bytes/sec

The Extended Events are the following:

sqlserver.hadr_apply_log_block
sqlserver.hadr_capture_log_block
sqlserver.hadr_database_flow_control_action
sqlserver.hadr_db_commit_mgr_harden
sqlserver.hadr_log_block_send_complete
sqlserver.hadr_send_harden_lsn_message
sqlserver.hadr_transport_flow_control_action
sqlserver.log_flush_complete
sqlserver.log_flush_start
sqlserver.recovery_unit_harden_log_timestamps
sqlserver.log_block_pushed_to_logpool
sqlserver.hadr_transport_receive_log_block_message
sqlserver.hadr_receive_harden_lsn_message
sqlserver.hadr_log_block_group_commit
sqlserver.hadr_log_block_compression
sqlserver.hadr_log_block_decompression
sqlserver.hadr_lsn_send_complete
sqlserver.hadr_capture_filestream_wait
sqlserver.hadr_capture_vlfheader

Regards,

Paul