December 20, 2020 at 9:59 pm
SQL 2008 R2 service pack1
SQL server not accepting connection
error in event log
A timeout (30000 milliseconds) was reached while waiting for a transaction response from the MSSQLSERVER service.
error in sql server errorlog
Using 'dbghelp.dll' version '4.0.5'
**Dump thread - spid = 0, EC = 0x0000000000000000
* BEGIN STACK DUMP:
* A fatal error occurred in .NET Framework runtime.
December 21, 2020 at 7:25 pm
First, I'd be looking at getting onto a newer SP for SQL 2008 R2... that thing is pretty old and out of mainstream support.
Next, I'd be asking a few questions:
1 - when did this start happening?
2 - how often does this error come up?
3 - is there a pattern with the error?
The first question helps address what you are looking FOR. If this worked in the past without issue for a while but suddenly has errors, the problem is that something changed. Determine what changed and undo that change (my guess - .NET was updated in a windows update). If it has always thrown this error or you are certain no changes happened on the server before the error started being thrown, are you on a compatible version of Windows for SQL 2008 R2?
Question 2 is more to identify if you can do a work-around to the problem. If the error happens on average once every 2 weeks, you could implement a short-term workaround while you try to solve the root cause by rebooting the server every week.
Question 3 is to see if MAYBE there is a scheduled process that is causing it to crash. This may be something like an antivirus scan locking the database files causing it to crash OR a SQL agent task that is causing the crash.
Seeing a STACK DUMP in the SQL Server Error Log though makes me think that the problem is most likely caused by either SQL Server 2008 R2 running on too new (or too old) of a Windows Version, or you need to install a newer SP to fix a known bug.
My next steps would be to replicate the server as closely as possible on a test server, replicate the stack dump, install newer SP's and/or update SQL to a supported version (2017 or newer). Do this in test so you can make sure the problem is solved AND no new problems crop up and then repeat in live.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply