64bit and 32bit sql server running at the same time?

Merlin-Eng
Merlin-Eng used Ask the Experts™
on
This is an ageing SBS 2008 server which is giving us performance issues. In the Task Manager I can see that there are 2 instances of SqlServer.exe running. One is the 64bit version and the other is the 32bit version. I just wanted to know if this is a normal scenario?

As far as I'm aware this is a standard installation of SBS. The 2 different executables are located at:

C:\Program Files (x86)\Microsoft Sql Server\MSSQL.1\MSSQL\Bin
and
C:\Program Files\Microsoft Sql Server\MSSQL10.MSSQLSERVER\MSSQL\Bin

In the Services window, I can only see the 64 bit version mentioned. So perhaps it is spawning the 32 bit version. Anyway I would just like to know if this is normal?

Task-Manager.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ste5anSenior Developer

Commented:
You can run install different versions of SQL Server on a machine. Different by edition, version and bit-ness. So yes, it could be normal.
Merlin-EngWorks Manager

Author

Commented:
I installed SQl Server, but i only recall installing it from the SBS dvd. Did that installation give me these two processes? I would like to get rid of the 32 bit version if it's not needed.
ste5anSenior Developer

Commented:
It depends on further software packages installed.. MOM, SCCM. There are many how bring their own SQL Server instance and installation.

Only way to check: Connect to each instance using SSMS as a local administrator and see what databases are installed. Most names are well known, so just search for it.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Merlin-EngWorks Manager

Author

Commented:
hmmm.... when I browse I can only see one SQL Server instance on the server. I can see an instance which is on a workstation, but that's not part of this conversation. I am looking only at the server.

And like I said previously. In the Services applet on the server, there is only one SqlServer Service listed.
ste5anSenior Developer

Commented:
You need to look at the SQL Server setup, not all instances of the tools I have in mind are browseable.

Run SQL Server Configuration Manager to get the instance names and connect to them explicitly.

Looks like this:
Capture.PNG
Merlin-EngWorks Manager

Author

Commented:
Ok. I found that now thanks. Here's what my Configuration Manager looks like. It's SBS Monitoring which is using the 32 bit instance. I would be happy to disable that if possible. We are not interested in it.

SQLCM.jpg
Senior Developer
Commented:
Then you can disable the monitoring service and also disable the instance SQL Server service.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
I would be happy to disable that if possible. We are not interested in it.
Uninstall it. Or it's not an option?
You can also stop the service and change it to manual start instead of automatic start.
Merlin-EngWorks Manager

Author

Commented:
Thanks Ste5an: your suggestion to look at the SQL Configuration Manager helped me to identify what the 32 bit Sql Server was being used for.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial