Janet Erbach
jerbach at gmail.com
Mon Jan 18 09:11:49 CST 2010
I do have SQL installed - and when I look at resource use through SysInternals Process Explorer, sqlserver.exe is always at the top of the list. I thought I had set up the memory usage config for my sql application so that it wouldn't eat up all available memory...but now that you bring it up I'd better check it again. I may have it set up wrong... Janet On Mon, Jan 18, 2010 at 9:02 AM, Gustav Brock <Gustav at cactus.dk> wrote: > Hi Janet > > Didn't you have SQL Server installed and running? It can eat - or rather > reserve - close to all available memory just to have it on hand. > > /gustav > > >>> jerbach at gmail.com 18-01-2010 15:56 >>> > 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 > > > > _______________________________________________ > dba-Tech mailing list > dba-Tech at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-tech > Website: http://www.databaseadvisors.com >