October 10, 2008 10:43pm pdt

My Account

Top 15 Experts

Overall Top Experts

1TechSoEasy 6,849,111
2RobWill 1,077,725
3Sembee 830,212
4leew 603,524
5olafdc 565,817
6KCTS 563,093
7suppsaws 334,515
8tigermatt 329,665
9redseatec... 251,556
10MPECSInc 229,856
11vico1 222,320
12Dave_AND 218,870
13ormerodru... 190,351
14keith_ala... 185,868
15MrMander... 183,623

	[x] Attachment Details

Multiple instances of sqlservr.exe in task manager on SBS 2003

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.0

Zones: SBS Small Business Server, Adobe Type Manager

Tags: multiple, instances

I currently manage 4 SBS 2003 installations. We ran into the issue at one installation of Exchange store.exe taking a large amount of memory and we recieved the warning. I've doen the research and have plans to deal with that. In my investigation, however, I came across the task "sqlserver.exe". I have never setup a SQL server on the system. More strange yet is that i noticed that there was not one, but TWO instances of sqlservr.exe running on the server. In case it matters I am remotely connected at this point.

To expand my search, i remoted to my other 3 installations. One of the other three had the same situation. So I have two installations that have two instances running, and I have the other two installations with only one instance running in the task manager.

The two sites that have two instances are both running exchange 2003, serving as their mail servers (internal and external). Both are running Trend Micro Server/Client/Messaging Suite for virus protection.

Of the two other sites. They are both running exchange as their mail servers (internal and external). One is protected by Symantec and the other the same Trend Micro product.

I can't seem to put things together to come up with a reason why some are doing it and others aren't. The main reason I'm asking is because these are taking large amounts of memory in proportion to the number of users they service.

Any advice? Thanks

	#	Title
	1	Problem with Trend Micro Spam Messa…
	2	Trend Micro vs Symantec
	3	trend micro
	4	Symantec or Trend Micro
	5	ISA 2004 and Symantec Client Secu…
	6	What version of security / antivirus /…