SQL 2005 64 bit performance issue | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL 2005 64 bit performance issue

We are in the process of moving to a 64 BIT SQL Server 2005 platform from 32 BIT. We have done some basic testing and the results in the new environment are quite poor. We have a simple select statement returning 100,000 rows and calling a simple UDF.
This takes 1 second on the 32 bit platform and 40 seconds on the new platform. The query is attached. The function does a few comparisons and returns a 0 or 1. select dbo.fct_function( dayDate, ’01/01/2007′, 11, 4)
from tblDimDate The new architecture is on a blade server SAN with 2 quad core processors and 14 GB RAM where as the old architecture is just 2 core processors with 8 GB RAM. Both the environments also have VMWare to manage the servers. Please suggest what we may be doing wrong. Any response will be highly appreciated.
See these KBAs
http://support.microsoft.com/kb/933724
http://support.microsoft.com/kb/926024 http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx – steps to troubleshoot in thsi case. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Sorry just one thing to add is that the new server is on SP2 and the old server is on SP1.
?? Have you checked the links above? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Yes Sayta. We are going to apply the hotfix suggested in the first link and see what difference it makes. BTW we created one more instance without any service pack just to make sure that SP2 is not an issue and it turns out that it is. The same code is working perfectly on the instance without any SP applied. I will come back with the results after applying the hotfix.
Thanks a lot Satya. Installing the hotfix has sorted out the issue.
]]>