Solved

Microsoft SBS 2003 R2 and SQL 2005 memory usage

Posted on 2008-10-29
3
272 Views
Last Modified: 2012-06-27
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
Comment
Question by:gmanea
  • 2
3 Comments
 
LVL 51

Accepted Solution

by:
Keith Alabaster earned 500 total points
ID: 22834538
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
 

Author Closing Comment

by:gmanea
ID: 31511342
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
 
LVL 51

Expert Comment

by:Keith Alabaster
ID: 22835748
Nice one :)
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sync conflicts 1 55
Replace SBS 2011 Exchange 2010 with Exchange 2016 3 98
Help with stripping out character in SQL LEFT/RIGHT/REPLACE 2 40
Password managers 1 16
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now