Janet Erbach
jerbach at gmail.com
Wed Jan 20 08:30:21 CST 2010
Mark - The boot up suggestion is an excellent one. I think I will try that this weekend. In the meantime virtual memory usage is up to 9.4gb...so I'm just waiting for the whole thing to melt down. Then I can go home and forget about it!! You just made me think of something, though. Do you think it's possible that this is a hardware issue and not a software one? Janet On Wed, Jan 20, 2010 at 6:13 AM, Mark Breen <marklbreen at gmail.com> wrote: > Hello Janet, > > I have a large online asp.net web app that is running now for 2 years. It > runs on a Dell Server with 2 GB ram, and a celeron processor, I bought the > server for €750 (approxd $1000 new from Dell). We handle 400 visitors per > day to the site for two years. And performance is always perfectly fine. > > I think that one thing is hogging your memory and you have to find that. > Moving SQL to another machine should not be a necessity for you, and > certainly not to another expensive server. > > What about immediately on boot up, can you watch the services coming up and > observer the memory increasing and identify the culprit? > > good luck, > > Mark > > > > 2010/1/18 Janet Erbach <jerbach at gmail.com> > > > 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 > > > > > _______________________________________________ > > 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 >