Janet Erbach
jerbach at gmail.com
Tue Jan 19 15:02:39 CST 2010
Sure - that would be fine! We are NOT running Exchange. We have no need of it, so all of those services are disabled (and the error logs complain about it EVERY DAY...there's no way to tell it to forget about it already). I also have set a couple of memory parameters in my sql database to try and limit usage, but I may not be doing it properly. So I would welcome that. Thanks! Janet On Tue, Jan 19, 2010 at 1:13 PM, Jim Lawrence <accessd at shaw.ca> wrote: > 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 > > > > _______________________________________________ > dba-Tech mailing list > dba-Tech at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-tech > Website: http://www.databaseadvisors.com >