Memory question

Hi,
I just started at a new company and have been tasked with reviewing the
configurations on some troubled servers. One thing I noticed that seems odd
in the sp_configure output is that the min memory per query (1024 MB) is
actutally higher than the max server memory (344 MB). Which setting has
priority or are they unrelated? Is this okay?
As a background note, this is a server with two instances. The primary
instance has it's max server memory set to 1024.
Thanks for your input.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200604/1Hi Michael
The min memory per query value is normally in kilobytes and the default is
1024KB do you have the correct value?
John
"michaelg via droptable.com" wrote:

> Hi,
> I just started at a new company and have been tasked with reviewing the
> configurations on some troubled servers. One thing I noticed that seems od
d
> in the sp_configure output is that the min memory per query (1024 MB) is
> actutally higher than the max server memory (344 MB). Which setting has
> priority or are they unrelated? Is this okay?
> As a background note, this is a server with two instances. The primary
> instance has it's max server memory set to 1024.
> Thanks for your input.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200604/1
>|||Hi John,
Yes, I see where I missed the MB vs KB in the output.
Thanks for the assistance.
Michael
John Bell wrote:[vbcol=seagreen]
>Hi Michael
>The min memory per query value is normally in kilobytes and the default is
>1024KB do you have the correct value?
>John
>
>[quoted text clipped - 8 lines]
Message posted via http://www.droptable.com