MS SQL Server - RE: Memory Issue: 64 bit Oracle 9 OLE DB Provider -> SQL Server 64 bit

Author

RE: Memory Issue: 64 bit Oracle 9 OLE DB Provider -> SQL Server 64 bit

Mike Epprecht (SQL MVP)

2005-08-03, 7:23 am

Hi

Start looking at the Oracle client. If it leaks memory, it will seem that
SQL Server is leaking it.

Have you applie
d SP4 yet? That will detect memory problems sooner due to the new compiler
settings Microsoft is using.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Phlippie Smit" wrote:

> I am experiencing an issue with SQL Server 2000 64 bit Enterprise Edition
> when selecting data into SQL Server tables from Oracle linked servers. SQL
> Server runs out of memory after running multiple "SELECT INTO" queries and
> the gives a stack overflow error. It seems like a memory leak, because the
> sqlservr.exe process just keeps on requesting memory, and does not release
> memory, even after the queries complete.
>
> The configuration is as follows:
>
> UNISYS ES7000 Server
> IA64 x 4
> 7GB RAM
>
> SQL Server 64 bit Enterprise Edition SP4
> Oracle 9i Client tools and Provider for OLEDB
>
> Are there anyone else who have experienced this? Where should I start
> looking?
>
> TYIA
>
> Phlippie Smit
>
>
>
>
>
>

Phlippie Smit

2005-08-03, 7:23 am

Thank you for the advice Mike.

It seems to be the provider causing the memory problem because I'm still
using version 9.2.0, and according to Oracle, there is a lot of leaks in
this version.

According to article
http://forums.oracle.com/forums/thr...=591941򐡅 memory
leak bugs were fixed.

Say I upgrade to another version, what would be the best way to test and
identify memory leaks? Is there software that can do this?

Sponsored Links