• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Microsoft SBS 2003 R2 and SQL 2005 memory usage

Hi!

I have a newly installed Dell 2900 server with 4GB RAM and SBS 2003 R2 with ISA and SQL 2005 and a bunch of accounting programs that were previously running on an older server with SBS 2000.  The SQL 2005 is not technically being used but was installed in advance for new software that can use it.  

The problem is that there are several instances of the MSSLQSVRs running and one of them is taking almost half of the available memory and loading files on the workstations is slow.  In the Add or Remove Programs there are several Microsoft SQL entries:

Microsoft SQL Server 2005
Microsoft SQL Server 2005 Backward Compatibility
Microsoft Server Desktop Engine (Microsoft ISA Server 2004 instance)
Microsoft Server Desktop Engine (SBSMonitoring)
Microsoft Server Desktop Engine (SHAREPOINT)
Microsoft Server Native Client

I looked in the SQL directory and the Server Desktop Engine entries are SQL 2000.

Anybody run into this problem before?  Any help would be greatly appreciated.  

PS:  As I am writing this, we are removing the SQL 2005 to see the effect on memory usage.

Thanks!
Gabe
0
gmanea
Asked:
gmanea
  • 2
1 Solution
 
Keith AlabasterEnterprise ArchitectCommented:
Yes, the SQL will try and make use of the memory available but you can limit it if you want with the osql commands.

This is what I used to fix it on my ISA server that used to use MSDE
http://www.smallbizserver.net/tabid/53/forumid/53/postid/4475/view/topic/Default.aspx
0
 
gmaneaAuthor Commented:
Had to hunt for "osql" which I had no idea what it was but after finding it and realizing that I had to change the scripts to include my server name and the position of the files, everything worked.  Thanks!
0
 
Keith AlabasterEnterprise ArchitectCommented:
Nice one :)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now