Mark Breen
marklbreen at gmail.com
Wed Jan 20 06:13:38 CST 2010
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 >