SQL Server 200 64-bit Performance issues

• Asser Maany

  SSC Enthusiast

  Points: 189

  More actions

  August 27, 2005 at 4:33 am

  #109900

  Hi There,

   We are testing a new SQL server 64-bit performance and results don’t seem

  to be logical.

  The new server configuration is

  • 4 Itanium-2 processors

  • 16 GB RAM

  • EMC CX700 15K RPM 73 GB HDD each, with a lot of cache memory in the box 8

  GB

  • SQL Server 64-bit with SP4 , on Windows 2003 64-bit edition.

  Amazingly we discovered was that the performance is slower than a normal

  32-bit server with the following configuration

  • Xeon dual processor

  • 4 GB RAM

  • EMC CX700 15K RPM 73 GB HDD each, with a lot of cache memory in the box 8

  GB

  • SQL Server 32-bit with SP4 , on Windows 2003 32-bit edition.

  We also noticed that some times a process blocks itself ! , how can this

  happen?

  I tried to check on Microsoft Web site and found that MS DTC was causing the

  problem and it was solved in SP4, but I’m having SP4 installed already!

  Are there any performance optimization tips available for SQL Server 64-bit

  for large hardware configuration (like what we used to do in 32-bit server,

  switching on AWE ,… etc) , I know that this doesn’t apply to 64-bit since

  can address 512 GB natively , but there might be some other optimization

  tips that I’m not aware of.

  Appreciate your help.

  Asser Maany