Solved

Disable SQL SBS 2003

Posted on 2011-03-02
7
1,304 Views
Last Modified: 2012-05-11
Hi all

I have an SBS server 2003 std r2 service pack 2

This server is running very slow
I use this server for exchange, file and print and several applications like Sage and Payroll

I have scanned this server with several virus and malware tools (there was no malware or virus found)
I have installed 3GB of RAM bringing this server from 1GB to 4GB  

Still this server is running very slow

In task manager store.exe and sqlservr.exe are the main RAM hogs

As far as I am aware I am not using SQL for anything (unless SBS needs it)

So my question is
Is there steep by steep instructions on how I can disable SQL and is it ok to disable it

Thanks
Robbie
0
Comment
Question by:IP4IT Staff
  • 3
  • 2
  • 2
7 Comments
 
LVL 9

Accepted Solution

by:
snurker earned 167 total points
Comment Utility
Abs uses the SQL server. There are probably other programs using it too. Open up the SQL configuration progrma and you can see all of the instances. You can also see these in services.
0
 
LVL 9

Expert Comment

by:snurker
Comment Utility
Abs uses the SQL server. There are probably other programs using it too. Open up the SQL configuration progrma and you can see all of the instances. You can also see these in services.
0
 
LVL 9

Expert Comment

by:snurker
Comment Utility
Sbs. Not abs. Stupid spell checker.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 3

Assisted Solution

by:chris2506
chris2506 earned 333 total points
Comment Utility
Store.exe is designed to take as much memory as it can, and there's nothing you can really do about that.

Is the server slow when you access it locally, or is the slow performance restricted to accessing services over the network?
0
 

Author Comment

by:IP4IT Staff
Comment Utility
Hi snurker: and chris2506:
All them spell checkers the same more trouble than there worth

kind of like this server

this server is very slow when I log in locally to the server
0
 
LVL 3

Assisted Solution

by:chris2506
chris2506 earned 333 total points
Comment Utility
Ok, well at least that rules out a couple of things. Are you sure that it's an issue with the memory (it seems that's where your question was focused)?

It may be worth using SBS 2003's Performance Monitor (if you haven't already) to check on I/O, disk reads etc etc to see if that throws any light on it.
0
 

Author Closing Comment

by:IP4IT Staff
Comment Utility
hi all
thanks for your help with this
this fixed it for me
http://msmvps.com/blogs/bradley/archive/2005/02/04/34984.aspx
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

728 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

12 Experts available now in Live!

Get 1:1 Help Now