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 Guinn1918
Michael Patrick1914
Robert Pearman1791
Nick Pieters1425
william warren651
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: SQL memory
Prev Next
You are not authorized to post a reply.

Author Messages
Michael Patrick User is Offline
United States
Member since
10/26/2005

Platinum Membership
Posts: 1914
3/16/2006 11:56 PM  
SQL dirves me crazy...I'll admit it....probably because I dont know it that well.....
 
I have about 12 users accessing a database...its not that large, only 3gb...  I was looking at my server's performance and SQLServer is using about 1.8gb of memory...  Now I understand the MSFW instance...but when it comes to the actual SQL Server instance, I am at a loss....  Is it normal for it to be using this much memory?  I thought Exchange was bad, but its only at 600mb...
 
Can I limit the amount of memory SQL uses like I did with MSFW?  And not have everyone complaining that their SQL connection is slow?
 
Thanks... 
Michael Patrick

"Technology Interpreter Extraordinaire"
CAD, BIM & SBS
william warren User is Offline
United States
Member since
12/8/2005

Registered Users
Posts: 651
3/17/2006 06:07 PM  
Are the users complaing about the server being slow?  If not then things are ok.  Yes for a database to be using that much ram is ok as long as the server is performing ok.
Registered Microsoft Partner
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > SQL memory


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.2812518 seconds.   :   Terms Of Use   :   Privacy Statement