December 14, 2006 at 8:35 am
Has anyone experienced problems with using a 32-bit version of SQL 8 (SP4) on a 64-bit server (Server 2003 Standard 64, R2, SP1)?
We have 3 core databases running on this server and every now and then we will get protocol errors or high levels of latency, despite the fact that the server itself is equipped with twin xeon processors running at 3ghz apiece and 16gb of RAM. The other level of complexity to this conundrum, is we are not using the standard SQL port (1433) for our communication to the server. So we have to remember to specify this non-standard port every time there is a connection established with databases on this server. So far this has not proved to be an issue, but perhaps there are certain settings within the MSSQL config that must occur should the port settings be different.
I'm wondering if A) there are settings within the config of the MSSQL install to better manage data traffic using the 32-bit version, or B) we would be better off using the 64-bit version of MSSQL...?
December 14, 2006 at 1:12 pm
A) there are settings within the config of the MSSQL install to better manage data traffic using the 32-bit version,
I don't think there any specail configuration you need for 32 bit sql on 64 bit server.
B) we would be better off using the 64-bit version of MSSQL...?
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1233009,00.html
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply