Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have had SQL Server 2012 on my server for about 6 months. Over the last few weeks, a problem has developed, whereby the SQL Server stops functioning, and any attempt to connect or query returns the error:

[SqlException (0x80131904): A severe error occurred on the current command. The results, if any, should be discarded.]

The SQL Server service is completely non-responsive. The only way to recover is to kill sqlservr.exe and restart the service. This happens annoyingly frequently, every couple of days or so.

I have looked through the Windows application logs, and found no clues. There are no errors reported; all I see are the application errors that start getting reported when the app can no longer connect to SQL Server.

Any ideas?

share|improve this question

closed as not constructive by gbn, Leigh Riffel, RolandoMySQLDBA, Paul White, Mike Walsh Jan 22 '13 at 16:41

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
What about the SQL Server logs? Also what do you mean by unresponsive. You can't get a connection? If so have you tried connecting via the DAC when this happens? –  Martin Smith Jan 15 '13 at 10:34
    
@MartinSmith Nothing in the SQL Server logs. Can't get a connection. What's the DAC, and how do you connect with it? –  Shaul Jan 15 '13 at 10:51
1  
Dedicated Administrator Connection. To start with, follow the instructions in that link to see if you can connect using the DAC. –  Mark Storey-Smith Jan 15 '13 at 11:20
    
@MarkStorey-Smith OK, thanks, next time it happens I'll give that a try! –  Shaul Jan 15 '13 at 11:33
1  
Have you installed service pack 1 and sp1 cu1? If not, please do so - there have been many fixes and not really any excuse to still be on RTM. See here for some more information. –  Aaron Bertrand Jan 15 '13 at 13:50
show 4 more comments