Hello, OSI PI Team
We have an issue where the process dllhost.exe triggered from MS SQL when running a query to PI it starts to increase the memory ram use
We are using
Windows Server 2008 R2
PI OLEDB 18.104.22.168
Are the queries run on a schedule and how often? How many rows and columns are returned per query? What is the initial memory and how fast does it grow? What is the version of PI SDK? Are there any errors in the Event Viewer logs associated with PI OLEDB? At this initial point, we should determine if this is memory growth or memory leak.
I realized that I ran a query to PI that did not have a WHERE Clause and cause the sql to take too long as well dllhost to increase the RAM very, I decided to stop the execution in SSMS but it was taking too long as well so I decided to Kill SSMS, when I did this the dllhost kept working at 6GB RAM and realized that my box was low in RAM and checked the process.
I replicated the scenario and when stopping the execution that was taking too long again instead killing the SSMS I killed the DLLHOST process and then query stopped in SSMS.
So there is not memory leak
Let me know your thoughts Barry
That sounds reasonable then. The unrestricted query probably caused dllhost to consume too much memory so stopping it will cancel the data acquisition by PI SDK.
Retrieving data ...