[dba-Tech] SBS 2008 performance

Hi Janet:

My friend replied but he is working a double shift... day and evening server
installs so he is a little over-loaded right now but he did say:

<comment>
SBS 2008 (R1) is basically "Vista server". It can work okay, but it's a bit
of a pig.
</comment>

Jim



-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Janet Erbach
Sent: Friday, January 15, 2010 6:30 AM
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] SBS 2008 performance

Jim - thank you for the link for running a test.  I will be running that
today.

Mark - thank you for the 'where to start looking' basics.  I have used task
manager many times to see what's sucking up CPU time, but nothing really
shows up (except for that one time where Acronis backup was using over 60%!
I've uninstalled Acronis since then).  I'll keep checking, though, and I'll
use Process Explorer, too, to see if there's additional detail there that
will show me something.  I'll let you know what I find.

Thank you both!

Janet

On Thu, Jan 14, 2010 at 3:46 AM, Mark Breen <marklbreen at gmail.com> wrote:

> Hello Janet,
>
> In my experience, there are loads of tools, but you can usually get 80% -
> 90% of the problem by checking a few basics.
>
> 1) 12 GB is great, so you are probably only using 2-3 gb, check this and
if
> it is the case, forget about SQL Server. on the other hand of something is
> using 9 - 10 gb you have a suspect.
>  (I doubt it)
>
> 2) Using plain old taskmgr , check what process is using most of your
> processing power - something is.  Identify that process and kill it.  Does
> your machine come back to life?
>
> Until these two steps are complete, I would not complicate matters, it
will
> be a simple problem and easy to fix, once you identify the culprit.
>
> I had a problem last year with McAfee AV and is was running a process that
> was killing the UI, I could not kill it, but could reboot, and once it was
> re-booted, it was OK.
>
> In summary,
>
> have you approx 9 GB ram free?
> on average is 99% of CPU resources free?
>
> Thanks
>
> Mark
>
>
> 2010/1/13 Janet Erbach <jerbach at gmail.com>
>
> > Hello!
> >
> > We're running SBS 2008 on an HP Proliant 370 G5 with a 2.67ghz processor
> > and
> > 12gb of ram.  I'm not an expert - (Damn it Jim, I'm an Access Developer
> not
> > a Network Administrator!) - but I'm convinced that I need to do some
> > serious
> > performance tune-ups on the server.  Console response time is pokey at
> > best,
> > and obscenely slow more often than I'd like - when it takes 30 seconds
> for
> > windows explorer to load, there's got to be something going on in the
> > background to cause it.
> >
> > Can anyone give me some pointers on where to start looking for
> performance
> > issues?  Does the built-in SBS Monitoring software need to be
> > custom-tweaked
> > to prevent it from negatively impact performance?  I could also use some
> > guidance in how to set memory usage allocations for sqlserver 2005 (we
> use
> > sql for our order processing application, and SBS uses it for monitoring
> > and
> > for WSUS).
> >
> > Thanks!
> >
> > Janet Erbach
> > IT Administrator
> > Natural Healthy Concepts
> > www.naturalhealthyconcepts.com
>  > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com