Error when limiting memory usage with OSQL.EXE

When trying to limit the memory usage of the SQL components of Small
Business Server, I get an error message I don't know what to do with.
I searched for an osql internal command reference, but all the references I
found are about specific problems.
Here is my input and the result:
osql -E -S sbs01\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
I intended to follow that with the following commands, but didn't get that
far:
sp_configure 'max server memory', 70
reconfigure with override
go

Reply in group, but if emailing add another
zero, and remove the last word.
I think you need to remove the first go or just run
> sp_configure 'max server memory', 70
> reconfigure with override
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||Hi Tom
What error message are you getting?
(If you're referring to this:
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
please note that is not an error. It is the normal response to any
sp_configure command to set a value. SQL Server doesn't check to see if the
next statement is the RECONFIGURE before generating this message.)
If that was the response, you were ready to go on, but it's probably a good
thing you didn't. Setting memory to only 70MB is not a good idea. Although
technically SQL Server might be able to run with this little, you probably
won't be able to get any work done at all.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uS6ahRhLIHA.2024@.TK2MSFTNGP05.phx.gbl
> Hi Tom
> What error message are you getting?
> (If you're referring to this:
> please note that is not an error. It is the normal response to any
> sp_configure command to set a value. SQL Server doesn't check to see
> if the next statement is the RECONFIGURE before generating this
> message.)
> If that was the response, you were ready to go on, but it's probably
> a good thing you didn't. Setting memory to only 70MB is not a good
> idea. Although technically SQL Server might be able to run with this
> little, you probably won't be able to get any work done at all.
Thanks all.
I should have mentioned that what I expected was "DBCC execution completed"
on the line following go. I thought that, without it, the command must have
failed.
I will use 100MB as Claus suggested. 70MB has worked with other SBS's and I
know I'm not the only SBS admin who has used that value, but I'll do as you
say.

Reply in group, but if emailing add another
zero, and remove the last word.