Mark Breen
marklbreen at gmail.com
Sat Jan 16 05:09:29 CST 2010
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 > >