Re: NEW SBS 2003 Purchase

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: IBC (spamityspam_at_spam.spam)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 10:36:16 -0600

snip>

however I am obviously
> concerned about my dual 3Ghz / 2GB RAM/ 72GB RAID 5 server being
> underpowered

snip>

Ok, Admittedly I don't use SQL and I know database applications can be
intensive, put I'm running SBS2000 on dual 533's (they maybe 733's, I'd have
to look that up again) with 1GB RAM. SQL is loaded, but nothing is taxing
it. I have yet to see my processor usage go over 8% on EITHER processor, and
the only reason the memory is all used up is because the exchange store
sucks up anything not currently in use. Hearing somebody with dual 3.0Ghz
processors and 2GB of RAM expressing concern about being underpowered almost
made me fall out of my chair laughing.

You can always have more, granted. I don't think anybody in their right mind
would instinctively put SQL, Exchange, ISA and the likes all on one box, but
Microsoft seems to have worked it out for SBS users. I think the idea was
that small business usually wouldn't stress any one of these components
excessively. There are white papers on Microsofts site that actually discuss
implementations and testing under load, I'd see if your situation is
comapable.

My gut tells me you should be just fine, but I recall a thread not too long
ago discussing Access or SQL applications not working properly for VPN users
with out having the database front end redone.......I'll see if I can find
the thread. I don't know if that applies here or not.

Relevant Pages

  • Re: 3vl 2vl and NULL
    ... although for some analytical reporting a list ... I'll grant) of SQL for the same tasks. ... issue in practice in PICK than in SQL shops, and less of an issue for ...
    (comp.databases.theory)
  • Re: Help with derived table SQL statement in Access
    ... Table aliases increase the clarity of SQL by explicitly noting each ... If I remove the where clause from the subquery, it works, but I get ... SELECT expression on the FROM clause, but that is just that, a table ...
    (microsoft.public.access.queries)
  • Re: Resolved: NOT (w/ informal proof). --Was Re: Static vs. Dynamic typing (big advantage or not)-
    ... > does not have a statically bound method implementing that message. ... Thank goodess SQL isn't statically compiled. ... given a row from the database with a column called contractKey I ...
    (comp.object)
  • Re: Just one more anecdote
    ... >> Marshall Spight wrote: ... ignorant, but when I'm not, I ... > Your recurring theme is limitations of SQL and the RM, ...
    (comp.databases.theory)
  • Re: 3vl 2vl and NULL
    ... >> What is the sum of the first and second Value1? ... I am very aware of the fact that SQL is not relational. ... >> - I have a family member who is uniquely identified (in the UoD of my ...
    (comp.databases.theory)