I just installed sql server 2005 on a sbs 2003 R2 server. There are no
applications using sql server yet but there will be soon. The sqlserver.exe
process is eating up 1.6GB of memory and slowing the system down. I see a
lot of posts talking about setting max memory size. I can't seem to find
anything in the SQL Server Configuration Manager to allow me to set the max
size. What am I missing?

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...erver/200806/1

SQL Server Configuration Manager is used for configuring things that are
'external' to SQL Server (e.g. start/stop the service, change service
account, change listening port, etc). 'Max server mmeory' is a setting inside
SQL Server. You can use SQL Server Management Studio. In Object Explorer in
SQL Server Management Studio, connect to the SQL instance, right click on the
connected instance, select Properties, and you should see an option for
Memory in the left pane. Click on that, and the option for max server memory
will appear on the left pane.

Linchi

"newdatabaser via SQLMonster.com" wrote:

> I just installed sql server 2005 on a sbs 2003 R2 server. There are no
> applications using sql server yet but there will be soon. The sqlserver.exe
> process is eating up 1.6GB of memory and slowing the system down. I see a
> lot of posts talking about setting max memory size. I can't seem to find
> anything in the SQL Server Configuration Manager to allow me to set the max
> size. What am I missing?
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums...erver/200806/1
>
>

Linchi
Isn't SQL Server consumed a memory by desing and releases it when it OS or
applications needs it. What should the OP set up for MAX memory in that
case? 1GB?

newdatabaser via SQLMonster.com

How much RAM do you have? Is it 64 Bit or 32 Bit?


"Linchi Shea" <LinchiShea@discussions.microsoft.com> wrote in message
news:3ED3819A-B976-4D89-9A48-5D288A919909@microsoft.com...
> SQL Server Configuration Manager is used for configuring things that are
> 'external' to SQL Server (e.g. start/stop the service, change service
> account, change listening port, etc). 'Max server mmeory' is a setting
> inside
> SQL Server. You can use SQL Server Management Studio. In Object Explorer
> in
> SQL Server Management Studio, connect to the SQL instance, right click on
> the
> connected instance, select Properties, and you should see an option for
> Memory in the left pane. Click on that, and the option for max server
> memory
> will appear on the left pane.
>
> Linchi
>
> "newdatabaser via SQLMonster.com" wrote:
>
>> I just installed sql server 2005 on a sbs 2003 R2 server. There are no
>> applications using sql server yet but there will be soon. The
>> sqlserver.exe
>> process is eating up 1.6GB of memory and slowing the system down. I see
>> a
>> lot of posts talking about setting max memory size. I can't seem to find
>> anything in the SQL Server Configuration Manager to allow me to set the
>> max
>> size. What am I missing?
>>
>> --
>> Message posted via SQLMonster.com
>> http://www.sqlmonster.com/Uwe/Forums...erver/200806/1
>>
>>

Yeah, it looks like it's a 32-bit system, and the OP didn't configure
anything special. In that case, it's common to see SQL Server using 1.6GB. I
don't think there is enough info from the OP to recommend a specific max
server memory setting.

Linchi

"Uri Dimant" wrote:

> Linchi
> Isn't SQL Server consumed a memory by desing and releases it when it OS or
> applications needs it. What should the OP set up for MAX memory in that
> case? 1GB?
>
> newdatabaser via SQLMonster.com
>
> How much RAM do you have? Is it 64 Bit or 32 Bit?
>
>
> "Linchi Shea" <LinchiShea@discussions.microsoft.com> wrote in message
> news:3ED3819A-B976-4D89-9A48-5D288A919909@microsoft.com...
> > SQL Server Configuration Manager is used for configuring things that are
> > 'external' to SQL Server (e.g. start/stop the service, change service
> > account, change listening port, etc). 'Max server mmeory' is a setting
> > inside
> > SQL Server. You can use SQL Server Management Studio. In Object Explorer
> > in
> > SQL Server Management Studio, connect to the SQL instance, right click on
> > the
> > connected instance, select Properties, and you should see an option for
> > Memory in the left pane. Click on that, and the option for max server
> > memory
> > will appear on the left pane.
> >
> > Linchi
> >
> > "newdatabaser via SQLMonster.com" wrote:
> >
> >> I just installed sql server 2005 on a sbs 2003 R2 server. There are no
> >> applications using sql server yet but there will be soon. The
> >> sqlserver.exe
> >> process is eating up 1.6GB of memory and slowing the system down. I see
> >> a
> >> lot of posts talking about setting max memory size. I can't seem to find
> >> anything in the SQL Server Configuration Manager to allow me to set the
> >> max
> >> size. What am I missing?
> >>
> >> --
> >> Message posted via SQLMonster.com
> >> http://www.sqlmonster.com/Uwe/Forums...erver/200806/1
> >>
> >>
>
>
>