SBS 2003 Server running slow

From: Jorge Melendez (jorge_at_melendez.com)
Date: 08/22/04


Date: 21 Aug 2004 20:59:47 -0700

I currently have a client who is running SBS 2003 with SQL installed.
I did not do the initial install of SBS, it was done by another person
who has recently abandoned the project and I was called it to
troubleshoot. Upon my investigation I found that the Sql service was
using about 1.2 gig of memory in task mananger. I rebooted and the SQL
services went down, but then jumped back up to about 900 meg.

The server config is a Dell Poweredge PIII 933 with 2 gig memeory and
3 36 gig drives. The clent is running an application called Everest
which uses the SQL database and the cleint is complaining that when
she pulls up a report it takes a long time. I have put in a call the
Everest to see if it may be something on their side, I have not heard
back yet. I have searched this group and saw the Knowledgebase
articles 316739 and 321169. I just want to make sure to check
everything on my end, am I still missing something? Should I be
thinking of adding an additional CPU? I would like to determine what
the problem is before I start throwing hardware at it.

Any help would be greatly appreciated. Thank you.



Relevant Pages

  • SBS 2003 Premium R2 Hardware Upgrade - Advice sought!
    ... We are now running SBS 2003 Premium Release 2 with SQL 2005. ... I presume we have two basic options: ... Get a second server and offload some of the applications on to it, ...
    (microsoft.public.windows.server.sbs)
  • Re: Hardward Recomendations Please?
    ... running SBS 2003 with SQL 2005. ... For SQL and Exchange on the same SBS hardware you NEED 4GB of RAM. ... to connect to their FTP site and download the latest maintenance ... Calling an illegal alien an "undocumented worker" is like calling a ...
    (microsoft.public.windows.server.sbs)
  • How do I tell which whether SQL has had a SP applied?
    ... Running SBS 2003 Premium SP2. ... Business Server 2003 Network" and got to the page about SQL. ...
    (microsoft.public.windows.server.sbs)
  • Backup strategy - looking for opinions
    ... We're running SBS 2003 R2 w/exchange plus SQL and Web servers joined to ... I'm going to be using Backup Exec for sbs, exchange, & sql. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2000 SP4 - ODBC Performance issues
    ... > Server is quad processor with 3 gig of RAM of whcih 2 gig is allocated to ... > Last weekend we upgraded the SQL from SP2 to SP4, ... > DB server is now using MDAC 2.81 since the upgrade and we have ensured the ...
    (microsoft.public.sqlserver.odbc)