Re: SQL & Memory configuration help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Chris Marsh (cmarsh_at_synergy-intl.com)
Date: 09/15/04 

Date: Wed, 15 Sep 2004 14:21:02 -0400

Yes, it is SQL that will climb. I forgot that SQL is crippled on SBS (it's
the standard version correct?) which has the 2GB limit. So, if I put 4GB's
into the box then SQL would max out at that point and the SBS box would have
2GB for everything else. On a 15 user LAN what should be the requirements?
Any suggestions on how I can see what is eating / hogging the RAM?

Thanks for the reply

"Steve Foster [SBS MVP]" <steve.foster@picamar.co.uk> wrote in message
news:xn0dnay9n5af87001@msnews.microsoft.com...
> Chris Marsh wrote:
>
>> I have a dual 1.4 w/2GB of RAM which after about 4-5 days is using
>> 2.4GB's of RAM. When we get to that point the server begins to
>> crawl. Does anyone know what I should change in the configuration or
>> what I should do to solve this problem? I know I can set SQL to say
>> 1GB of RAM but then the server would still be maxing out at 2GB most
>> of the time.
>
> Is it definitely SQL Server that's using more RAM than anything else?
>
>>
>> Of course, more RAM would help but SQL might also just continue to
>> eat the remaining RAM.
>
> SQL Server is capped at 2Gb per instance. It cannot exceed that on SBS.
>
> --
> Steve Foster [SBS MVP]
> ---------------------------------------
> MVPs do not work for Microsoft. Please reply only to the newsgroups.

Relevant Pages

  • Re: how do I change the user install wizard to create user folder in different location?
    ... Les Connor [SBS Community Member] ... >> Regarding SQL and Sharepoint, ... >> file where I'm suppose to register the SHAREPOINT instance of SQL Server ... another install which is on just Windows 2003 server and SQL2000 ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL service pack 4 & SBS 2003 premimum version
    ... Thank you for posting in the SBS newsgroup. ... SBS SharePoint with SQL ... whether SQL server is being installed or not. ... it will install the sixteenth instance of MSDE ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS
    ... I'm not seeing performance issues with the full enchilada installed, and 25 users busy hitting SQL. ... WSUS isn't difficult to uninstall - if you have WSUS v2 (installed with SBS R2) uninstall R2 from add/remove programs. ... How can anyone work with 4 instances of SQL Server on the same box? ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS
    ... Les Connor [SBS MVP] ... Is your server exhibiting significant performance problems, and if so, how ... SQL Server: ... >No wonder SBS brings servers with 4GB of RAM to their knees. ...
    (microsoft.public.windows.server.sbs)
  • Re: Outlook for MAPI on SBS
    ... I wound up looking at another thread here on installing SQL 2005 which I ... I have noticed something interesting here in SBS ... agent from the SBS Monitoring Agent to the 2005 agent instance. ... Is there an easy way to set up notifications from SQL Server ...
    (microsoft.public.windows.server.sbs)