Re: SBS 2003 SP2 Memory

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Thank you all for your responses however we are a small company. 13 Users
currently and most of these users only utilize Exchange. QB usually has no
more than 3 users at any given time. MISYs is in start up mode so I'm
normally the only one in there getting the data configured properly. And we
are running BPS instead of BES and only have the 1 user for that. I'm not a
database GURU by any means so I dont have the knowledge to tell if one or all
of them are causing this issue. When it goes into "limp" mode or does not
respond for a period of time I dont know how to see which if any of the SQL
instances may be the bottleneck. Also... I dont know how to see if my
physical hard drives are being maxed out. I can tell what the volumes are
doing but because it's hardware RAID I cant see the activity on the
individual physical drives. Does anyone know how to do this?

Thanks everyone for your responses!

"Susan Bradley" wrote:

Cliff Galiher wrote:
You are running a *lot* of applications. SBS is a good small business
solution, but it does enough on its own that "other" apps do better on a
second server. That is why SBS Premium comes with SQL server and a
second windows license.

Specifically, BES and BPS (the blackberry server, you didn't specify
which) are both memory heavy. I'm not familiar with MISys, but ERP apps
in general are also SQL transaction heavy and that gobbles ram too.
Quickbooks? Same deal.

Any one of those is enough to justify a separate application server.
All three? Darn near a requirement. I'm surprised you aren't having
more problems than you are.

-Cliff


"R. Riddle" <RRiddle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F5010D5D-0D66-4749-AE41-B3780D627B70@xxxxxxxxxxxxxxxx
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.


That's 5 SQL instances over and above the ones that ship on the box.

That is a lot on one box.

http://msmvps.com/blogs/bradley/archive/tags/Allocated+Memory/default.aspx
Read those posts and stomp on the SQL instances that ship on the box.

.



Relevant Pages

  • Re: Restore from dmp file
    ... our SQL database on a dmp file. ... We reinstalled Win Server 2003 SE w/ SQL 2000 Server SE. ... '' is not a valid Microsoft Tape Format backup set. ...
    (microsoft.public.sqlserver.server)
  • Re: Connecting to SQL Database
    ... Is the database on the same server as SharePoint or a separate server? ... The SQL database authentication method is ... SharePoint server with Active Directory Users & Computers. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Backup and restore question
    ... SQL BI Product Unit ... If you are referring to the 2000 version then archiving and restoring ... the database from one server to the other should work fine as long as ... But it can also be stored in a SQL database if you chose the option ...
    (microsoft.public.sqlserver.olap)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)