none
SSISS package memory usage

    Question

  • SSIS Package uses resources of the server on which it is running, but does it use memory allocated to sql server or memory outside of it??

     


    123pal
    Tuesday, September 06, 2011 2:35 PM

Answers

  • HiNep123,

    The key counters for Integration Services and SQL Server are:

    1. Process / Private Bytes (DTEXEC.exe) – The amount of memory currently in use by Integration Services. This memory cannot be shared with other processes.
    2. Process / Working Set (DTEXEC.exe) – The total amount of allocated memory by Integration Services.
    3. SQL Server: Memory Manager / Total Server Memory: The total amount of memory allocated by SQL Server. Because SQL Server has another way to allocate memory using the AWE API, this counter is the best indicator of total memory used by SQL Server. To understand SQL Server memory allocations better, refer to Slava Ok’s Weblog
    4. Memory / Page Reads / sec – Represents to total memory pressure on the system. If this consistently goes above 500, the system is under memory pressure.

    For more information about it, please see the article as below,
    SSIS: Memory Usage: http://consultingblogs.emc.com/jamiethomson/archive/2005/05/29/SSIS_3A00_-Memory-Usage.aspx

    Thanks,
    Eileen

    • Edited by Eileen Zhao Thursday, September 08, 2011 9:55 AM
    • Marked as answer by Eileen Zhao Wednesday, September 14, 2011 2:10 AM
    Thursday, September 08, 2011 9:51 AM

All replies

  • If the SQL Server is configured the default way likely it grabbed ~ 90% of RAM memory (gradually preallocates it). It is a good practice to limit the amount of memory the SQL Server can use in case heavy SSIS processing is expected, otherwise SSIS will swap some memory to disk.

    So typically SSIS would not "touch" the memory allocated to the SQL Server database engine.


    Arthur My Blog
    By: TwitterButtons.com
    Tuesday, September 06, 2011 2:45 PM
  • HiNep123,

    The key counters for Integration Services and SQL Server are:

    1. Process / Private Bytes (DTEXEC.exe) – The amount of memory currently in use by Integration Services. This memory cannot be shared with other processes.
    2. Process / Working Set (DTEXEC.exe) – The total amount of allocated memory by Integration Services.
    3. SQL Server: Memory Manager / Total Server Memory: The total amount of memory allocated by SQL Server. Because SQL Server has another way to allocate memory using the AWE API, this counter is the best indicator of total memory used by SQL Server. To understand SQL Server memory allocations better, refer to Slava Ok’s Weblog
    4. Memory / Page Reads / sec – Represents to total memory pressure on the system. If this consistently goes above 500, the system is under memory pressure.

    For more information about it, please see the article as below,
    SSIS: Memory Usage: http://consultingblogs.emc.com/jamiethomson/archive/2005/05/29/SSIS_3A00_-Memory-Usage.aspx

    Thanks,
    Eileen

    • Edited by Eileen Zhao Thursday, September 08, 2011 9:55 AM
    • Marked as answer by Eileen Zhao Wednesday, September 14, 2011 2:10 AM
    Thursday, September 08, 2011 9:51 AM