Applies ToSQL Server 2016 Service Pack 2 SQL Server 2016 Service Pack 1

Symptoms

Assume that an instance of Microsoft SQL Server 2016 restarts, for example, because of a system restart. During startup, if SQL Server tries to start Query Store Manager, you may receive an access violation error intermittently. Because of the access violation, SQL Server fails to start automatically. Therefore, you may have to start SQL Server manually. Additionally, an error message that resembles the following is logged in the SQL Server error log:

Date/Time Starting up database 'master'.Date/Time Using 'dbghelp.dll' version '4.0.5'Date/Time ***Stack Dump being sent to FilePath\FileNameDate/Time SqlDumpExceptionHandler: Process 5 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.Date/Time * *******************************************************************************Date/Time *Date/Time * BEGIN STACK DUMP:Date/Time * Date/TimeDate/Time *Date/Time *Date/Time * Exception Address = 00007FFF2BF59AFB Module(sqlmin+00000000011D9AFB)Date/Time * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATIONDate/Time * Access Violation occurred reading address 0000000000000000Date/Time *Date/Time *Date/Time * MODULE BASE END SIZE

Resolution

This issue is fixed in the following cumulative updates for SQL Server:

Each new cumulative update for SQL Server contains all the hotfixes and security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

Latest cumulative update for SQL Server 2016

References

Learn about the terminologythat Microsoft uses to describe software updates.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.