Re: allocated memory alert after sp1
- From: "Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]" <sbradcpa@xxxxxxxxxxx>
- Date: Sun, 28 Aug 2005 12:18:05 -0700
Don't ask me why but 100 seemingly is 125ish. Mine does the same thing.
MikeR wrote:
Well...I didn't see anything in bold but I entered literally what you wrote subbing my servername of course, and set the max memory to 100mb. That did the trick. One puzzling thing though is that it seems that sql server doesn't exactly behave like you tell it to. The monitoring instance is at 124 mb??? By far better than the 750mb that it was though.
"David Copeland [MSFT]" <davidcop@xxxxxxxxxxxxxxxxxxxx> wrote in message news:OIzl5q1qFHA.3016@xxxxxxxxxxxxxxxxxxxxxxx
Mike,
OSQL is a command line way to access SQL. The fact that you are getting the 1> prompt means that you have a connection to that instance. At that point it would be a matter of entering in the other commands.
Osql -E -S %computername%\sbsmonitoring 1> sp_configure 'show advanced options',1 2> reconfigure with override 3> go 1> sp_configure 'max server memory',NNNN 2> reconfigure with override 3> go 1> exit
You would type in what is in bold and press the <Enter> key on the end of each line. Keep in mind that the NNNN is the max amount of ram to use.
--
Hope that helps, David Copeland Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
SBS Newsgroups:
SBS v4.x: microsoft.public.backoffice.smallbiz SBS 2000: microsoft.public.backoffice.smallbiz2000 SBS 2003: microsoft.public.windows.server.sbs
"Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]" <sbradcpa@xxxxxxxxxxx> wrote in message news:OhVmOH0qFHA.2076@xxxxxxxxxxxxxxxxxxxxxxx
Those instructions 'should' work
Call Product support as if they don't... I'm not sure what's going on.
As this is an issue with a SP install the call should be comp'd.
MikeR wrote:
Thanks Susan, it looks like that is exactly my problem but the instructions don't work for my server. For some reason if I type "Osql -E -S myserver\sbsmonitoring" I get a "1>" returned ??? Each time I hit enter the number goes up by one???--
I don't get the configuration screen at all.
"Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]" <sbradcpa@xxxxxxxxxxx> wrote in message news:uK0jQ8xqFHA.2880@xxxxxxxxxxxxxxxxxxxxxxx
Store is fine...
Which instance?
http://msmvps.com/bradley/archive/2005/02/04/34984.aspx http://msmvps.com/bradley/archive/2005/05/22/48500.aspx
Check out these posts
MikeR wrote:
--Hi All,
Started getting an allocated memory alert again after sp1. Looks lie store and sql server are the largest at 573 & 719 respectively. Any ideas?
An open letter to the Security Community:: http://msmvps.com/bradley/archive/2004/12/12/23540.aspx
An open letter to the Security Community:: http://msmvps.com/bradley/archive/2004/12/12/23540.aspx
--
An open letter to the Security Community:: http://msmvps.com/bradley/archive/2004/12/12/23540.aspx
.
- References:
- allocated memory alert after sp1
- From: MikeR
- Re: allocated memory alert after sp1
- From: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]
- Re: allocated memory alert after sp1
- From: MikeR
- Re: allocated memory alert after sp1
- From: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]
- Re: allocated memory alert after sp1
- From: David Copeland [MSFT]
- Re: allocated memory alert after sp1
- From: MikeR
- allocated memory alert after sp1
- Prev by Date: OT: Lock VPN settings from being Changed by user?
- Next by Date: Re: Error with sharepoint services.
- Previous by thread: Re: allocated memory alert after sp1
- Next by thread: server activesync after sp1 - broke
- Index(es):
Relevant Pages
|
