Re: SBS 2003 SP2 Memory



I can use perfmon however I normally do not know what should be my baseline.
Is there a good reference site or document that lists the major counters and
good baseline specs? I followed the suggestion of Leythos above and the
results were not as good as I had hoped. I set the page file to 4096 min/max
and set all SQL instances to use only 256MB and every odd processor. After
multiple reboots last night I'm currently at 4.45GB PF with Physical Memory
Available of 2.25GB. I wont know if anything has helped until the problem
returns but I'll run some perfmon counters to see if I can determine what the
existing bottlenecks are. Sharepoint and Microsoft##SSEE have been removed as
they were not being used.

"Al Williams" wrote:

Use perfmon to look at your paging file IO to see if it is a bottleneck.
This counter is one of the better indicators of actual pagefile usage
bootlenecks according to what I've read:

Memory, Pages Output/Sec - this shows how many virtual memory pages were
written to the pagefile to free RAM page frames for other purposes each
second.

See:
http://support.microsoft.com/kb/555223

Generally with servers you should have enough RAM that you shouldn't be
using your pagefile at all. As others have said some SQL tuning may be in
order but you have an awful lot on that one box. You can also use Perfmon
to see if you have other bottlenecks like a slow I/O subsystem.

Given the strange login behaviour it sounds like you have other issues
though. Best to tackle each separately. Anything in the event logs when
you login?


--
Allan Williams




R. Riddle wrote:
I have a HP Proliant ML350 G5 running 2 quad core processors @
2333MHz and 4GB of ram. This machine has 2 150GB SATA hard drives
mirrored for the OS and 4x512GB hard drives in RAID 5 for data,etc.
Its the only server in my network and I'm running the following:

Exchange 2003
Blackberry Server (sql database)
Symantec Backup Exec (sql database)
MISys SBM ERP (sql database)
QuickBooks Pro 2007 (Quickbooks database manager)
SonicWall ViewPoint 5.0 (MYsql database)
Mcafee Groupshield

These are the main applications. The problem I have is in the Task
Manager I'm showing the PF usage to hover around 5.0GB and there are
times where the server will go unresponsive for anywhere from 30sec
to minutes (usually no more than 5min). I'll do a reboot and all will
run well for a few days then it starts again. When it does this
nothing is different that I can see. Processor usage is always low
and the PF usage is always between 4.7GB and 5GB. When I try to log
in to the server it can take up to 30 minutes and normally hangs on a
black screen (at the console) or it will sometimes show me "applying
user settings" via remote desktop.

I've had no luck whatsover determining the problem thus far so I'm
wondering if I am set up to use my 4GB of memory correctly. Here is
my boot.ini switches:

/noexecute=optout /fastdetect /pae

I understand I may be looking at multiple issues here so anyone that
has ideas please chime in.



.



Relevant Pages

  • Re: SBS 2003 SP2 Memory
    ... This counter is one of the better indicators of actual pagefile usage ... Its the only server in my network and I'm running the following: ... Symantec Backup Exec (sql database) ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 SP2 Memory
    ... Normally with server 2003 you set memory usage to cache but with SBS there ... Also - I'd let your server run for a few days and see what your free memory ... Symantec Backup Exec (sql database) ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 SP2 Memory
    ... It just may be a factor of how much you have going on on your server. ... can't control) and see what you can do to reduce their RAM footprint. ... tuning each of them based on usage so watch their RAM usage for a ... Symantec Backup Exec (sql database) ...
    (microsoft.public.windows.server.sbs)
  • SBS 2003 SP2 Memory
    ... Its the only server in my network ... Symantec Backup Exec (sql database) ... QuickBooks Pro 2007 (Quickbooks database manager) ... I'm showing the PF usage to hover around 5.0GB and there are times where the ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 SP2 Memory
    ... I wonder if Cris meant the /3GB switch, which should not be used on SBS. ... I'm pretty sure /PAE is OK - DEP requires PAE, so if you turn on DEP, you'll get PAE automatically without it showing in the boot.ini. ... Windows Small Business Server 2008 Unleashed ... Symantec Backup Exec (sql database) ...
    (microsoft.public.windows.server.sbs)