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 >