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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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
ste5anSenior DeveloperCommented:
Then you can disable the monitoring service and also disable the instance SQL Server service.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.