on 11-01-2016 8:02 PM
Hi
We use ADS Ver. 11.10.0.22 OLE DB provider to connect MS SQL server with ADS database. We see now that after each SQL access the memory of the OLE driver increases by about 70 kB. After a while the complete server hangs.
Has anyone an idea about a solution or any experience connecting MS-SQL with ADS
Any help is welcome as this is a vital problem.
Thanks
Marcus
Hi
We did some test scenarios:
1. we tried a different MS OLE DB driver just to read data from another database. No memory leak. This might indicate, that the memory leak is not on the MS side. An ADS OLE DB select * from view always consumes about 5 MB. We can see this in the taskmanager. We put 128 GB RAM in the server so it lasts for 1 week until Sunday when we restart the server to free the memory. Maybe in your test scenario you should not close the connection between two select statements to see what happens then.
2. We set up a completely new environment with ADS 12 to check if this is any help. When we have results I will let you know.
Regards
Marcus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Marcus,
We tried setting up an OLE DB connection from a Visual C# application. We didn't try writing to the MS SQL Server database, since that would be done with a different driver and not likely part of the equation. We queried the database in a loop. We tried using the default connection pooling and we tried destroying the existing connection between each query. In no case were we able to reproduce the memory leak.
If you can provide a precise set of conditions (data types involved, size of data sets, frequency, custom connection settings etc.) we can try again. However, it would probably be more effective to open a support incident.
Regards,
Mike Loop
Senior Support Engineer
SAP Product Support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.