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
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?