asked on 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
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]()
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
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?
SBSMicrosoft SQL Server
Last Comment
Merlin-Eng
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.
ASKER
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.
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.
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.
ASKER
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.
And like I said previously. In the Services applet on the server, there is only one SqlServer Service listed.
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]()
Run SQL Server Configuration Manager to get the instance names and connect to them explicitly.
Looks like this:
ASKER
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]()
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
ASKER
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.