we have migrated our SQL Installation to following configuration:
Server with 2 Xeon CPU with each 4 Kernels, running at 2.4 GHz, 76 GB Ram, Fijitsu Storage DX90, connected with Dual Controller and ISCSI, VMWare 5.0, 1GBit Ethernet
The Virtual server on this machine has 20GB Ram, all 8 Kernels from the CPUs, and 12 GB Ram for the SQL Server.
Before migration.: The List Window of child records from the table "contacts" has had a normal performance. The are about 50000 records. The child-table itself has about 30 calculated field (all of type lookup into the table contact).
After migration: The list window of the child table performs very, very poor, after setting filter, it is a desaster.... one record is shown, the waiting 5 secondes, another record, and so on.
Hopefully waiting for tips