Share via

SQL Server 2022 with CU 10 periodically crashes

Ron Ross 0 Reputation points
2024-01-04T15:06:56.1+00:00

We have a database that we backed up and restored from a 2016 version of SQL Server - we are seeing 2022 periodically crash and restart - we are getting dump files indicating there was an EXCEPTION_ACCESS_VIOLOATOIN reading specific addresses - there doesn't seem to be any consistency in what was being executed at the time of the crash (based on information in the dump files) - anyone else seeing SQL Server crashes in 2022 CU10 (16.0.4095.4)?

  • Exception Address = <frame id="00" address="0x7FFEC76765B8" pdb="sqllang.pdb" age="2" guid="A71002FB-EB59-45BE-8081-D0CC20ABA9EB" module="sqllang" rva="0x2965B8" />
  • Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,447 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 116.5K Reputation points MVP
    2024-01-04T22:31:13.59+00:00

    Such crashes are often a token of bugs in SQL Server, and you would do best in opening a support case.

    Although, before that you may ask yourself, if you are using any of:

    • Extended stored procedures.
    • sp_OAxxxxxx
    • Unsafe assemblies.
    • Third-party linked servers (including OPENROWSET) that run in-process.

    These are things that could go and scribble the SQL Server memory with the result that SQL Server gets confused and crashed.

    Bad memory sticks can also be the culprit.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.