none
Virtual memory Is spiking | Need help RRS feed

  • Question

  • HI Experts,

    Need your help, we have one  SSIS server ,where we have SQL installed and it host SSIS catalog database.

    We see virtual memory issues are coming on the server from long time. But Due to load increase from last Friday from a particular package ,we see more virtual memory issues in Windows logs from then . Due to this there is an business team escalation.

    Please advise ,if there is anything to changeSQL side to make it free from Virtual memory issues ?

    Here are the server specs:

    RAM:16 GB

    SQL minimum Memory:0

    SQL maximum memory: 2 GB

    paging Size in windows: 3 GB

    From above details,please help to find if there is anything to change from SQl side to get rid of this issue.

    many thanks in advance !

    Regards,

    Naren

    Tuesday, December 10, 2019 2:41 PM

All replies

  • >>SQL maximum memory: 2 GB

    Set MAX memory to 12 GB


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Tuesday, December 10, 2019 2:49 PM
  • Hi Naren,

    It appears that SQL Server has run out of large memory blocks to allocate to the process.

    Low amount of available memory might indicate external memory pressure, please configure memory options to raise the memory ceiling.

    Best Regards,

    Lily


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Proposed as answer by Lily Lii Thursday, December 12, 2019 6:20 AM
    Wednesday, December 11, 2019 2:34 AM
  • Hi Uri Dimant,

    please advise, how SQL Max memory is related to virtual memory issue ?

    Besides that, to be more specific on this issue, this server is a SSIS catalog DB server, package which is running on this server is doing a data pump from Oracle server to another SQL prod server. Kindly advise, how this virtual memory exist on SSIS catalog DB server is related to this issue ?

    Many thanks in advance ! 

    Regards,

    Naren


    Monday, December 16, 2019 6:15 AM
  • Hi Naren,

    Forgive my poor understanding, there may not be enough available virtual address space in SQL Server process in the following conditions when you are running SQL Server with the default configuration values:

    1. The server has 2 GB or more of RAM.

    2. There are a large number of databases on the system.

    3. Most of the databases are updated.

    4. There are enough user connections to use most of the 255 SQL Server worker threads.

    Resource Governor will be useful to manage SQL Server workload and system resource consumption.

    Best Regards,

    Lily


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, December 17, 2019 8:09 AM
  • Hi Naren,

    Physical memory size is related to Virtual memory in terms that when physical memory is less Windows/SQL Server will start paging process to this virtual memory or page file. In your case RAM is just 2 GB which is very very less and you are going to face memory issue.

    You have 12 GB why have you allocated just 2 GB to SQL Server.


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Tuesday, December 17, 2019 8:38 AM
  • Hi Naren,

    Do the answers above help you? It's so kind of you to mark helpful replies as answers in order to close this thread. By doing so, it will benefit all community members.

    Best Regards,

    Lily


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, December 18, 2019 9:25 AM