none
Message :A significant part of sql server process memory has been paged out.

    Question

  • Hi,

            I have a SSIS package, which got failed with the message:"The step did not generate any output.  The return value was unknown.  The process exit code was -1073740940.  The step failed". Since the message was not clear for me, I have started checking the logs, so  , I could see the below message.

            " A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 6070 seconds. Working set (KB): 65960, committed (KB): 300048, memory utilization: 21%.". My system has 25 GB RAM, The following are the other attributes:

    1) Page life expectancy is above 20000

    2)Memory from sql server property :24574 MB

    3)Min server memory :0 MB

    4)Max server memory:2147483647 MB

    Please let me know that can be the reason

    Thursday, August 22, 2013 8:23 AM

Answers

  • The package is running from SQL server jobs, and failed with error on the job history "The step did not generate any output.  The return value was unknown.  The process exit code was -1073740940.  The step failed". There is no other error message. When I ran the package next time from the job, it got success.
    Did you enable SSIS logging?

    MCSE SQL Server 2012 - Please mark posts as answered where appropriate.

    Friday, August 23, 2013 6:37 AM

All replies