|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Error when limiting memory usage with OSQL.EXEBusiness 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 Show quote "Tom Del Rosso" <td***@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. > > Your advanced options are already set to 1 (enabled).
Now run the second set and you should be fine. I don't see an error. I would also recommend using 100 instead of 70. -- Show quoteClaus "Tom Del Rosso" <td***@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 please note that is not an error. It is the normal response to any > RECONFIGURE statement to install. 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. Show quote "Tom Del Rosso" <td***@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. > >
Show quote
"Kalen Delaney" <replies@public_newsgroups.com> wrote in message Thanks all.news:uS6ahRhLIHA.2024@TK2MSFTNGP05.phx.gbl > 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. 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.  |
|||||||||||||||||||||||
Other interesting topics