Unanswered: Dl-380 Server Hangs With Erp - Sql-server 2005 Db And 2003 Server
We have recently migrated from an HP server to a new one, HP DL-380, 6 Disks ( 2 o.s. Mirror 1 + 3 database Mirror 5 + 1 Hot spare ), we instaled Windows 2003 Server, SQL-SERVER 2005 SP2 ( the old one had SQL-SERVER 2000 ) and we are runing and ERP systems that runs with Sql-Server.
We instaled the server and the soft and run it in production about a month ago, since almost the first day, the server hangs up when we run some random parts of the ERP program.
We request hp to change the mother, check the memories, the procesor, etc they told as that this isn't a hardware issue.
After further research we found that the only clue in this problem, the only big diffrence between the old server and the new one, ( among the Sql-Server version ) is that the Collation sequence is differnt, the server has ModernSpanish, the database is using SQL_Latin1_General_CP1_CI_AS, the same that has almost all other clients instalations.
We are not sure if the source of the prolbem is this, but we are runing out of ideas here. We change the Sql-Server user name that runs the process, created a new one. Again the same result.