[dba-Tech] SBS 2008 performance

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
>