[dba-Tech] SBS 2008 performance

Jim Lawrence accessd at shaw.ca
Tue Jan 19 13:13:19 CST 2010


I am current working with a Network Tech and good friend at a client's site
installing the same server package. It is a porker; the first thing we did
was turn off Exchange so it could run system in real time while we tried to
configure it. There is a setting that will limit the built in MS SQL from
consuming all the systems resources... I can send you info along as soon as
I have the details...?

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 12:37 PM
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] SBS 2008 performance

Mark -

I used SysInternals Process explorer to look at resource usage.  Right now
we're using almost 4.9g of virtual memory and 4.4g of physical memory.  I've
attached a screen shot.  This last weekend when Steven and I logged into the
server from home we found that virtual memory was up to nearly 9g...Is 4.9
high?

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
>




More information about the dba-Tech mailing list