Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778

    Unanswered: Error - There is insufficient system memory to run this query.

    Hello,

    We receive this error after running a complex query. Could someone please shed some light on what this means exactly?

    One of our developer said we needed to purchase a server with more memory, but would SQL Server not simply just run slower by using virtual memory instead of physical RAM?

    I know there is a limit and servers must be upgraded as the processing requirements increase, due to data set size increases for example, but we have just been told to "purchase more power because after a while as you process more rows, SQL Server will require more resources"

    Any comments on this would be really appreciated.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    the "complex query" may be written inefficiently. if you post the code, i am sure someone will help you. see Bretts sticky on the top of the page.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    The query is not important, meaning we wish to understand the specific cause of the error. Whilst executing the query, we observed that tempDB was only ~20% full and there was plently of virtual memory available. Does SQL Server require a certain amount of Physical RAM available even though there is an abundance of Virtual available.

    Thanks.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  4. #4
    Join Date
    Jun 2003
    Posts
    269

    Talking

    Quote Originally Posted by Thrasymachus
    the "complex query" may be written inefficiently. if you post the code, i am sure someone will help you. see Bretts sticky on the top of the page.
    Sean,
    he will not post the code.Forget it.This is not the first time that he is not posting the code. http://www.dbforums.com/showthread.php?t=1211545
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

  5. #5
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    I am perfectly happy if people choose not to reply, however I must point out that your previous comment was grossly inappropriate.

    The code is in no way relevant to my question, which was further explained in my second reply. Whether or not the portion of code in question is complex or not is immaterial. I do not require assistant with optimizing this particular portion of SQL code, so please do not request I rewrite my question. I intentionally did not provide the code, as to take attention away from the real underlying issue.

    I will also point out that as general courtesy both in an online and offline environment, should you not agree with another person's viewpoint or method of which they have gone about something, the mature response is to not get involved and leave it to those who may, should any chose to do so.

    Thank You.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  6. #6
    Join Date
    Jul 2002
    Posts
    229
    I assume you have done a Google on the error message, and tried to exclude other causes of the message?

  7. #7
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    It is not inappropriate or irrelevant. Bad sql can cause all kinds of trouble.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •