R Services Error: cannot allocate vector of size RRS feed

  • Question

  • Folks,

    I am running queries and utilizing r external scripts. I keep getting "cannot allocate vector of size" errors even though I have plenty of ram and I have changed the rlauncher.config file to up the MEMORY_LIMIT_PERCENT. but I am still getting these errors for relatively small vectors.

    Do I need to do something else to allow R Services to use more memory?


    • Edited by [Mick] Wednesday, May 10, 2017 2:59 PM text keeps encoding badly
    Wednesday, May 10, 2017 2:55 PM

All replies

  • It's possible that you haven't changed the default external resource governor pool. By default this is 20% of the overall system memory. How much memory is available on your database?

    Wednesday, May 10, 2017 7:09 PM
  • Thanks for replying.

    Yeah I did that....

    ALTER RESOURCE POOL "default" WITH (max_memory_percent = 30);  

    ALTER EXTERNAL RESOURCE POOL "default" WITH (max_memory_percent = 70);  

    This is SQL Server 2016 standard edition and it would not allow me to run the following


    But I restarted and the following

    SELECT * FROM sys.resource_governor_external_resource_pools WHERE name = 'default'  

    shows the correct figures for modified max_memory_percent for external

    • Edited by [Mick] Wednesday, May 10, 2017 7:20 PM formatting from grammarly
    Wednesday, May 10, 2017 7:20 PM