I have this exact same issue. The server genereates memory warning alerts
because of this, every week or so. How do you set the min/max memory with
the tools available in SBS2003? There appears to be no SqlServer tools?
> Thank you. I'll check that out.
>
[quoted text clipped - 23 lines]
> > >
> > > Thanks in advance for any help on this matter.
Can you use osql.exe (a DOS-level tool) to connect to the database server
and execute the appropriate sp_configure statement?

Signature
Keith Kratochvil
>I have this exact same issue. The server genereates memory warning alerts
> because of this, every week or so. How do you set the min/max memory with
[quoted text clipped - 30 lines]
>> > >
>> > > Thanks in advance for any help on this matter.
DDigweed - 31 May 2006 13:37 GMT
Yes, thanks Keith, thats what I finally did. I'm new to the 2003 SBS server,
and was surprised how difficult it was to find this answer.
I asumed that SBS was supposed to be easy(ier) for a Small Business Customer
to manage. This issue started a couple weeks after the packaged Dell server
was installed, and repeats every week, sending out badly formatted warning
messages that cause the customer to be concerned that his server will crash.
There is no way for the customer to resolve this without some fairly expert
help. Having to go in and "tune" the memory useage of SQL server using a
text-based tool like osql just seems to defeat the whole purpose of the SBS
product.
Wondering if the problem might be a Dell install issue, as another thing
they did is create one tiny and one huge partition on the disk array, and
then installed all components of SBS on the tiny partition. Within days
after the install the customer was getting low disk space warnings cause by
the Exchange email store......
> Can you use osql.exe (a DOS-level tool) to connect to the database server
> and execute the appropriate sp_configure statement?
[quoted text clipped - 33 lines]
> >> > >
> >> > > Thanks in advance for any help on this matter.