Unfortunately, I got some error in my SQL throwing the below error string,
"CImageHelper::Init () Failed load of dbghelp.dll - Invalid access to memory location" Reason for this issue: 1. It's a well know issue reported in Microsoft products and it should be a protocol issue. Disabling force encryption for the protocols will resolve the problem. ![]()
2. If the problem persists, we need to think in a different perception for this problem. It may be due to memory issue with SQL Server. By default, SQL Server will take the server memory as MAX upto 2147483647 MB (SQL express) and the new process will try to use the new memory instead of utilising the existing memory. In that case, we need to restrict/set the Max server memory capacity. Below is the query to achieve it, EXEC sys.sp_configure N'max server memory (MB)', N'50'
GO
RECONFIGURE WITH OVERRIDE
GO
After applying above command to the database the memory size is restricted to ~ 50 MB for the same test.
Cheers,
Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/