Jim Lawrence
accessd at shaw.ca
Mon Jan 18 12:43:01 CST 2010
MS SQL 2007 must take a lot of resources. I have an older Server2003 with both MS SQL 2005 and Reporting services running and when not under load take a scant 50MB, a far cry from the 6+ GB you are reporting. Here is a link that might give you some insight into how MS SQL consumes memory and suggested steps to take to reduce or manage impact: http://support.microsoft.com/kb/321363 Jim -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Janet Erbach Sent: Monday, January 18, 2010 7:12 AM To: Discussion of Hardware and Software issues Subject: Re: [dba-Tech] SBS 2008 performance 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 > _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com