Comments
5 comments
-
It's not something I've come across before; are you able to engage Microsoft at all to see what the error code actually means? Are there any dump files being generated you could examine?
https://www.sqlservercentral.com/forums/topic/cimagehelperinit-failed-load-of-symbol-file-with-path
-
Hello Russell,
thank you so much for your answer.
There are no dump files, no other corresponding entries in SQL or Windows log files, no jobs (except SQL Monitor) that always run at the time in question.
On one server the errors stopped suddenly and without any changes, on the other one they appear in the SQL log about 200 times per day.
This is really puzzling. I had already read the sqlservercentral article, but unfortunately it doesn't help because no solution is described and he doesn't write if the problem was fixed after the reboot. The recovery interval for all DB's on both servers was set to 60 from the beginning.
Next week we will patch and boot both servers, see what it looks like afterwards.
-
Yes I realise the link wasn't the most helpful, I was just hoping it might shed some light on it. Really all I can suggest at this point is to ask Microsoft - it's not a particularly satisfactory answer I'm afraid.
-
peter eh said:Hello Russell,
thank you so much for your answer.
There are no dump files, no other corresponding entries in SQL or Windows log files, no jobs (except SQL Monitor) that always run at the time in question.
On one server the errors stopped suddenly and without any changes, on the other one they appear in the SQL log about 200 times per day.
This is really puzzling. I had already read the sqlservercentral article, but unfortunately it doesn't help because no solution is described and he doesn't write if the problem was fixed after the reboot. The recovery interval for all DB's on both servers was set to 60 from the beginning.
Next week we will patch and boot both servers, see what it looks like afterwards.
Hi Peter, did you find the solution? We are also getting this error sporadically (daily) on one of our Prod 20016 Ent SQL Servers,
thanks Simon.
-
peter eh said:Hello Russell,
thank you so much for your answer.
There are no dump files, no other corresponding entries in SQL or Windows log files, no jobs (except SQL Monitor) that always run at the time in question.
On one server the errors stopped suddenly and without any changes, on the other one they appear in the SQL log about 200 times per day.
This is really puzzling. I had already read the sqlservercentral article, but unfortunately it doesn't help because no solution is described and he doesn't write if the problem was fixed after the reboot. The recovery interval for all DB's on both servers was set to 60 from the beginning.
Next week we will patch and boot both servers, see what it looks like afterwards.
Thanks, SImon
Add comment
Please sign in to leave a comment.
All monitored instances are SQL Server 2017 CU15 GDR.
All servers are Windows 2016 with current patch level.
Any ideas?