0

On one of my databases, the integrity check keeps failing with the error:

Connection may have been terminated by the server. [SQLSTATE HY000] Msg 596, Sev 21, State 1: Cannot continue the execution because the session is in the kill state. [SQLSTATE HY000].

There is nothing else going on that I can tell and so this is a particularly hard thing to solve. It's as if the database is timing out or something on the CheckDB command.

  • 5
    When checkdb fails, there are usually a bunch of other error messages. Have you checked event viewer or the error log? That message often appears when your drive runs out of space for the snapshot checkdb takes. – Erik Darling Jan 8 at 21:26
  • 1
    And if it is a space issue, that you can't get around, i'd check out Paul Randal's blog on breaking up VLDB. – scsimon Jan 8 at 21:42
  • Is the database in an Availability Group or Cluster? I have seen this issue on a few AGs/Clusters where there is an underlying performance problem that actually triggers failovers or partial failovers which is the cause of the killed connection. – HandyD Jan 9 at 5:43
  • Does it fail at the same time from start? If you have exhausted the other options, make sure there isn't a process that kills connections that have been alive for X minutes. Usually an agent job that someone put in to prevent long running queries from consuming all resources. – Jonathan Fite Jan 9 at 14:04
  • I am low on space. Perhaps I should increase the drive space for the database. However, when I add additional disk space it doesn't seem to matter at all. I still get the same errors. – Brian Custer Jan 12 at 2:35
0

I would recommend check space on data file of your database and extended in case there is only 5% free of space.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.