KB4470811 - FIX: Log message displays “N/A” when using ring buffer target to hold extended event data in memory in SQL Server

Symptoms

Assume that you have an instance of Microsoft SQL Server 2017. If you use ring buffer target to briefly hold extended event data in memory, the log message may display “N/A,” and the buffer may overflow.

Resolution

The fix for this issue is included in the following update for SQL Server:

Cumulative Update 13 for SQL Server 2017

About SQL Server builds

Each new build for SQL Server contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest build for your version of SQL Server:

SQL Server 2017 build versions

Workaround

To work around this issue so that the log message is captured correctly, use a target other than a ring buffer target.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the standard terminology Microsoft uses to describe software updates.