Update adds AlwaysOn extended events and performance counters in SQL Server 2014 or 2016

Summary

This update improves SQL Server 2014 and SQL Server 2016 support for troubleshooting latency issues in AlwaysOn availability groups.

More Information

This update adds the following new AlwaysOn extended events:
  • recovery_unit_harden_log_timestamps
  • log_block_pushed_to_logpool
  • hadr_log_block_compression
  • hadr_log_block_decompression
  • hadr_transport_receive_log_block_message
  • hadr_log_block_group_commit
  • hadr_capture_filestream_wait
  • hadr_lsn_send_complete
  • hadr_receive_harden_lsn_message

It also changes the following existing extended events:
  • log_flush_start
  • log_flush_complete
  • hadr_apply_log_block
  • hadr_capture_log_block
  • hadr_capture_vlfheader
  • hadr_log_block_send_complete
  • hadr_send_harden_lsn_message
  • ucs_connection_send_msg

This update introduces the following new performance counters:

CounterComment
RedZones/secThe number of log blocks RedZone in the last second to catch up the database replica.
Group Commit TimeNumber of microseconds all transactions group commit waited.
Group Commits/SecNumber of times transactions waited for group commit.
Log Bytes Compressed/secThe amount of log in bytes compressed per sec.
Log Compressions/secThe number of log blocks compressed per sec.
Log Compression Cache misses/secThe number of log block compression cache misses per sec.
Log Compression Cache hits/secThe number of log block compression hits per sec.
Log Bytes Decompressed/secThe amount of log in bytes decompressed per sec.
Log Decompressions/secThe number of log blocks decompressed per sec.
Database Flow Control DelayDuration spent in database flow control wait.
Database Flow Controls/secThe number of database flow control per sec.
Encryption I/Os/secThe number of transport encrypted I/Os per second.
Be aware that a transport send I/O may contain more than one message fragment.
Encrypted I/O bytes/secThe number of transport encrypted I/O bytes per second.
Decryption I/Os/secThe number of transport decrypted I/Os per second.
You should be aware that a transport send I/O may contain more than one message fragment.
Decrypted I/O bytes/secThe number of transport decrypted I/O bytes per second.
Send Flow Control GateUCS send boxcars pending on flow control gate exit.
Send Flow Control Enters/secUCS send flow control enters per sec.
Send Flow Control Exits/secUCS send flow control exists per sec.
Receive Flow Control GateUCS receive messages pending on flow control gate exit.
Receive Flow Control Enters/secUCS receive flow control enters per sec.
Receive Flow Control Exits/secUCS send flow control exits per sec.


This update is included in the following service pack for SQL Server:


About service packs for SQL Server
About service packs for SQL Server

References

Learn about the terminology  that Microsoft uses to describe software updates.
Eigenschaften

Artikelnummer: 3173156 – Letzte Überarbeitung: 08.12.2016 – Revision: 1

Feedback