05-27-2025 04:00 AM
I'm going crazy trying to find the cause of a memory leakage problem.
I have a LabVIEW executable running as a service on a server that read via modbus some data from a device and write results to a MSSQL database.
Somehow, at a certain point the RAM memory of the executable goes from 40 to 400MB. and it returns an error.
"system error 8: Not enough storage is available to process this command. (ODBC Driver 17 for SQL Server, C:\Windows\SysWOW64\msodbcsql17.dll)"
It is not a DB problem or a driver problem but a memory problem.
I'd like to find when and how the memory leak occur, if it happens gradually or suddenly.
So I would like to monitor, like in task manager a specific task and it's memory occupation.
I found something similar here
https://forums.ni.com/t5/LabVIEW/How-to-monitor-total-memory-occupied-by-a-running-project/td-p/1725...
But it uses the same application to get the task ID, I need to select the task ID from the running task like in task manger and all the memory info it returns doesn't seems to be the one I can see in the task manager...
I tried running the executable on my laptop and it doesn't give any problem.
05-27-2025 07:36 AM
@gepponline wrote:
It is not a DB problem or a driver problem but a memory problem.
I'm not sure why you say that, since the error clearly identifies itself as coming from the ODBC driver.
I'm not saying that you don't have a memory issue, but I have personally never seen this error and 400 MB for a process is usually not a reason to see an out of memory error.
I would suggest digging through some of these: https://www.google.com/search?q=%22sql+server%22+%22not+enough+storage+is+available+to+process+this+...
05-27-2025 08:05 AM
05-27-2025 08:42 AM
05-27-2025 08:42 AM