Skip to Content
0
Former Member
Jul 17, 2008 at 06:24 PM

Strange Memory Leak (Huge!) with Data Services (Integrator)

1197 Views

We are preparing for a software release of a BI product that uses Data Services (Intergrator) Release 3.

Database Platform - (standalone database no other software installed)

HW - Dell 6850, with 4 quad-core CPUS, 4 GB memory, pagefile 4 GB

SW - Windows 2003 SP2, SQL Server 2005 SP2 (9.00.3054.00) Max memory set to 2 GB minimum set to 500 MB.

Data Services Platform - identical to database platform, standalone just BO software installed. 11 R3

ETL job run will take over 11 hours. Pagefile will fill up, physical memory will peg to nearly 4 GB. Task Manager, though shows only 250 MB for all current processes. BODI processes only show about 120-140 MB of memory.

3.8 GB of physical RAM and 3.2 GB of pagefile are being used on the database server, yet Task Manager Processes only shows 250 GB of RAM in use. Nothing else is running on the server except SQL Server, the OS processes and Trend Office Microscan Client.