Janet Erbach
jerbach at gmail.com
Mon Jan 18 08:56:09 CST 2010
Mark - Just as an update...As of this morning, virtual memory/physical memory usage is pretty near 7 gb. It's been that way all weekend. I tried turning off the services I could find that were related to SBS Monitoring, but that made no difference in memory usage. I'm going to investigate the possibility of un-installing Monitoring altogether; and then I'll probably have to look into disabling other SBS 'standard-you-gotta-have-em' services as well. It sure looks to me like SBS 2008 is a resource hog by default, and that I'll have to turn off quite a few things before I see any improvements. We're also looking at investing in a second server for our main sql server application, so that should help a little. In theory. Janet On Sat, Jan 16, 2010 at 5:09 AM, Mark Breen <marklbreen at gmail.com> wrote: > Hello Janet, > > I am not an expert, but I think it is high. Most of the OS's that I run > only use about 1 GB, and then if I have SQL Server it can often use another > GB or even 1.5 GB. > > So what is using 9 GB of virtual memory, or even 4.9 of physical memory. > > To repeat what I may not have said so clearly in my earlier email, when I > have a machine that is crawling, I usually expect it to be one thing that > is > killing the machine and when that is fixed, all comes back to normal. > > It sounds like you are getting closer. > > thanks > > Mark > > > > 2010/1/15 Janet Erbach <jerbach at gmail.com> > > > 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 > > > > > _______________________________________________ > dba-Tech mailing list > dba-Tech at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-tech > Website: http://www.databaseadvisors.com >