Professional Web Applications Themes

minimum query memory - Microsoft SQL / MS SQL Server

Sounds like your pressed for memory on that server. Are you running anything else other than sql server on the machine? -- Andrew J. Kelly SQL Server MVP "Hutch" <chutchinsonnospam.com> wrote in message news:00ce01c347bd$347045b0$a101280aphx.gbl... > We are running into an error today that I have not seen > before > > "Could not perform the requested operation because the > minimum query memory is not available. Decrease the > configured value for the 'min memory per query' server > configuration option." > > After I receive the error I can not perform any operations > in EM or query yzer. ...

  1. #1

    Default Re: minimum query memory

    Sounds like your pressed for memory on that server. Are you running
    anything else other than sql server on the machine?

    --

    Andrew J. Kelly
    SQL Server MVP


    "Hutch" <chutchinsonnospam.com> wrote in message
    news:00ce01c347bd$347045b0$a101280aphx.gbl...
    > We are running into an error today that I have not seen
    > before
    >
    > "Could not perform the requested operation because the
    > minimum query memory is not available. Decrease the
    > configured value for the 'min memory per query' server
    > configuration option."
    >
    > After I receive the error I can not perform any operations
    > in EM or query yzer. The solution I have found this
    > morning is to stop and restart the services, a full reboot
    > has to be scheduled and can not be done till late today.
    >
    > The error appears as though it is not able to read the min
    > query value. If anyone has found a solution a tip we
    > greatly help
    >
    > Thanks
    >
    > Hutch
    >
    >

    Andrew J. Kelly Guest

  2. #2

    Default Re: minimum query memory

    I wouldn't go just by task manager. If your running multiple apps on the
    same box they can adversely affect the performance of sql server. Do you
    have an upper memory limit set for sql server currently? How much ram do
    you have in total?

    --

    Andrew J. Kelly
    SQL Server MVP


    "hutch" <hutchnospam.com> wrote in message
    news:0ba201c347c4$43425a90$a501280aphx.gbl...
    > There are several things running. When I check task
    > manager only 1/3 memeory is being used.
    > After checking msdn and reading about the error it looks
    > like there is something not cleaning up after itself
    >
    >
    > >-----Original Message-----
    > >Sounds like your pressed for memory on that server. Are
    > you running
    > >anything else other than sql server on the machine?
    > >
    > >--
    > >
    > >Andrew J. Kelly
    > >SQL Server MVP
    > >
    > >
    > >"Hutch" <chutchinsonnospam.com> wrote in message
    > >news:00ce01c347bd$347045b0$a101280aphx.gbl...
    > >> We are running into an error today that I have not seen
    > >> before
    > >>
    > >> "Could not perform the requested operation because the
    > >> minimum query memory is not available. Decrease the
    > >> configured value for the 'min memory per query' server
    > >> configuration option."
    > >>
    > >> After I receive the error I can not perform any
    > operations
    > >> in EM or query yzer. The solution I have found this
    > >> morning is to stop and restart the services, a full
    > reboot
    > >> has to be scheduled and can not be done till late today.
    > >>
    > >> The error appears as though it is not able to read the
    > min
    > >> query value. If anyone has found a solution a tip we
    > >> greatly help
    > >>
    > >> Thanks
    > >>
    > >> Hutch
    > >>
    > >>
    > >
    > >
    > >.
    > >

    Andrew J. Kelly Guest

Similar Threads

  1. Query Results too much for memory
    By naMwodahS in forum Coldfusion Database Access
    Replies: 2
    Last Post: March 24th, 03:52 PM
  2. #25656 [Opn->Bgs]: Not able to set the minimum value
    By pollita@php.net in forum PHP Development
    Replies: 0
    Last Post: September 25th, 02:35 PM
  3. #25093 [Opn->Csd]: no way to free failed query => memory leak
    By sniper@php.net in forum PHP Development
    Replies: 0
    Last Post: August 15th, 12:05 PM
  4. #25093 [NEW]: no way to free failed query => memory leak
    By pvx at pv2c dot sk in forum PHP Development
    Replies: 0
    Last Post: August 14th, 11:50 AM
  5. There is insufficient system memory to run this query.
    By MattD in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 9th, 05:58 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139