SQL Server Error: There is insufficient system memory to run this query

  • Friends, we are getting "there is insufficient system memory to run this query" error while working. My machine uses 9.00.4285.00, SP3, Enterprise Edition.

  • Sql server log or bids / ssms?

    The message can't really be more clear than that. Add more ram or use less ressources in your query.

  • sqlnaive (7/14/2011)


    Friends, we are getting "there is insufficient system memory to run this query" error while working. My machine uses 9.00.4285.00, SP3, Enterprise Edition.

    Need more info.

    How much total RAM have?

    OS version?

    Which bit is it?

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • muthukkumaran Kaliyamoorthy (7/14/2011)


    sqlnaive (7/14/2011)


    Friends, we are getting "there is insufficient system memory to run this query" error while working. My machine uses 9.00.4285.00, SP3, Enterprise Edition.

    Need more info.

    How much total RAM have?

    OS version?

    Which bit is it?

    Bit or built?

  • Ninja's_RGR'us (7/14/2011)


    muthukkumaran Kaliyamoorthy (7/14/2011)


    sqlnaive (7/14/2011)


    Friends, we are getting "there is insufficient system memory to run this query" error while working. My machine uses 9.00.4285.00, SP3, Enterprise Edition.

    Need more info.

    How much total RAM have?

    OS version?

    Which bit is it?

    Bit or built?

    32 or 64 bit

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • Microsoft SQL Server Management Studio 9.00.1399.00

    Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)

    Microsoft MSXML2.6 3.0 4.0 5.0 6.0

    Microsoft Internet Explorer7.0.5730.13

    Microsoft .NET Framework2.0.50727.3053

    Operating System5.1.2600

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply