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

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
Merlin-EngWorks ManagerAsked:
Who is Participating?
 
ste5anConnect With a Mentor Senior DeveloperCommented:
Then you can disable the monitoring service and also disable the instance SQL Server service.
0
 
ste5anSenior DeveloperCommented:
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.
0
 
Merlin-EngWorks ManagerAuthor 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.
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
ste5anSenior DeveloperCommented:
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.
0
 
Merlin-EngWorks ManagerAuthor 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.
0
 
ste5anSenior DeveloperCommented:
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
0
 
Merlin-EngWorks ManagerAuthor 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
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
 
Merlin-EngWorks ManagerAuthor 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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.