Registered users    
MembershipMembership:
Latest New UserLatest:Taganova Ronya
New TodayNew Today:12
New YesterdayNew Yesterday:9
User CountOverall:23415
Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12968
Marina Roos12627
Eriq Neale2117
Stan Guinn1917
Michael Patrick1914
Robert Pearman1791
Nick Pieters1425
william warren650
Stewart Brown620
Kevin D.579
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000
Subject: Exsessive memory use
Prev Next
You are not authorized to post a reply.

Author Messages
Rene van Veen User is Offline
Oslo Norway
Member since
4/16/2005

Platinum Membership
Posts: 148
10/18/2005 03:26 PM  
Hi Y'll,

I know a lott of you are stuggling withh this, or may be you have n't found out jet. But after the Small Business Server prem upgrade SQL is running wild with RAM. In my case I use a box's that have to Xeon processors and 3GB ram to nic's and Scsi kontrollers. I tweak start up for exchange and mem use as shown by Marina. I also tweak'd every SQL instance to use X amount memory, if your not doing this it runs just higher and higher untill it runs out.   OK this works but how do we find out what amount of memory each instance needs in a growing DB? Should we tweak and tune from day to day? Ore is MS comming with a patch to correct this feature?

Rene, Oslo
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12627
10/19/2005 02:05 AM  
Hi Rene,
 
'A lot of you'? I don't think so. I have never had to tweak anything on all servers I maintain. What 3rd party stuff is running on that server?
Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Rene van Veen User is Offline
Oslo Norway
Member since
4/16/2005

Platinum Membership
Posts: 148
10/19/2005 03:08 PM  
No spesial third party. Backup exec 10.0 uses SQL, windows firewall, sbsmonitor, antivirus (panda), It's spesialy the local instance that runs wild. The servers I maintain that are not upgradet yet behave normal without extreme memory use. As I told after the upgrade spesialy the local instance want's to use all availeble memory over some time, it stops at the limmit if I set one and works fine.
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12627
10/19/2005 04:50 PM  
Hi Rene,
 
You can do without Backup Exec as the Small Business Server Backup wizard does a perfect job. About Panda, have you contacted them about this?
Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Rene van Veen User is Offline
Oslo Norway
Member since
4/16/2005

Platinum Membership
Posts: 148
10/20/2005 10:43 AM  
Backup exec followed with the package so old habbit i installed. Panda wasn't installed for after 10 day's (had to wait for some upgrade) thus I know for shure that the behavior was there before Panda.

Appreciat your input
Rene, Oslo
Ze'ev Ionis User is Offline
Canada
Member since
6/13/2005

Platinum Membership
Posts: 56
10/25/2005 05:01 AM  
I also am running into this problem. I have Small Business Server 2003 Premium with ISA 2004 and SQL Server, and SQL is eating up memory. Every morning I get a report that it is using a lot of memory. The only 3rd party software is Trend Micro officescan.
Mariette Knap User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12968
10/25/2005 11:23 AM  
Mariëtte Knap Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Ze'ev Ionis User is Offline
Canada
Member since
6/13/2005

Platinum Membership
Posts: 56
10/26/2005 05:32 PM  
Article: How to limit the amount of Ram ISA logging takes

Thanks Mariette - that did the trick for me!
Ze'ev Ionis
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > Exsessive memory use


ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.
Copyright 2002-2008 Concentrix b.v.    :   Page generated in 0.3437522 seconds.   :   Terms Of Use   :   Privacy Statement