Is it possible to remove MS SQL Server from SBS 2003?

[deekydoo]

Hi,

My client does not use MS SQL Server for anything. Is it used by any SBS software (eg ExChange etc)? At the moment I can see three instances of sqlserver running as processes, so I am a bit mystified as to what is triggering them.

Any advice much much appreciated,

Deek

 

[ShackDaddy]

What you are looking at are instances of the light-weight SQL 2000 MSDE used to handle Sharepoint and some SBS server monitoring. Sometimes they use more memory than they should, but you should NOT be trying to remove them. To throttle their memory use, check out this thread:

http://www.tek-tips.com/viewthread.cfm?qid=1491810&page=1

Exchange doesn't use SQL. The process called "Store" is what Exchange uses to handle its database.

Don't think of the SQL you are seeing as "full blown with a lot of overhead," while the memory usage for monitoring sometimes gets out of hand, the file footprint is pretty small. Again, it's not something that would be good to remove. It may affect system stability.

Dave Shackelford
Shackelford Consulting

 

[deekydoo]

Thanks Shackdaddy,

I'll leave sql server alone then..

Something is building up to slug the system heavily though. 'CDPService' for example clocks up to 660 page faults at a time. 'Sophos' is going online to update every 5 minutes. CDPService' is page faulting consistently = as if two or more processes are fighting for memory?

Has anybody else come across a situation where the LAN is fine when the server is rebooted but then gradually declines until it is unusable?

Thanks for listening to my whinging,

Deek

 

[ShackDaddy]

Page faults aren't as nasty as they sound. That just means that you lack physical memory and that the application is having to read data from your hard disk instead because RAM was storing data in your page file instead of in fast real-RAM. How much memory does your server have installed?

Add columns to your Task Manager: VM Size, Peak Memory Usage.

How much memory is your largest instance of SQLSERVER using?

The CDPService isn't something native to SBS. Did you install some Cisco tools on that server? Are you doing packet sniffing? That would create a lot of overhead.

Dave Shackelford
Shackelford Consulting