question

Hi Team, Recently we migrated one of our application to new server. (I have provided server configuration of NEW server and OLD Server. New Servers configuration are pretty high compared to old server) Issue : When we try to Insert 2 million records from ONE table to another table in NEW Server it takes 2 Minutes While in old server it takes just 30 seconds. Also OLD Server is loaded with lot of databases still, execution is faster there. We did below steps in both old and new server 1.INDEX Rebuild 2.Update stats 3.Max memory for SQL SERVER in NEW is capped at 140 GB in New server (192 is total RAM) WHILE Max memory for SQL SERVER in OLD server is capped at 40 GB in old server (64 is total RAM) The logical read and Physical reads number are pretty same in OLD and NEW Server. SQL server version are same in both server while there is diffenerce in OS verion. Any help on this will be appreciated. --------NEW SERVER CONFIGURATION------------------ OS Name: Microsoft Windows Server 2008 R2 Enterprise OS Version: 6.1.7601 Service Pack 1 Build 7601 SQL Server Version Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Total Physical Memory: 196,598 MB Available Physical Memory: 71,532 MB Virtual Memory: Max Size: 803,289 MB Virtual Memory: Available: 676,394 MB Virtual Memory: In Use: 126,895 MB System Manufacturer: HP System Model: ProLiant DL580 G7 System Type: x64-based PC Processor(s): 4 Processor(s) Installed. [01]: Intel64 Family 6 Model 47 Stepping 2 GenuineIntel ~1060 Mhz [02]: Intel64 Family 6 Model 47 Stepping 2 GenuineIntel ~1060 Mhz [03]: Intel64 Family 6 Model 47 Stepping 2 GenuineIntel ~1060 Mhz [04]: Intel64 Family 6 Model 47 Stepping 2 GenuineIntel ~1060 Mhz BIOS Version: HP P65, 7/1/2013 --------OLD SERVER CONFIGURATION------------------ OS Name: Microsoftr Windows Serverr 2008 Enterprise OS Version: 6.0.6002 Service Pack 2 Build 6002 SQL Server Version Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Total Physical Memory: 65,532 MB Available Physical Memory: 648 MB Page File: Max Size: 163,605 MB Page File: Available: 89,242 MB Page File: In Use: 74,363 MB System Manufacturer: HP System Model: ProLiant DL580 G5 System Type: x64-based PC Processor(s): 4 Processor(s) Installed. [01]: Intel64 Family 6 Model 29 Stepping 1 GenuineIntel ~2666 Mhz [02]: Intel64 Family 6 Model 29 Stepping 1 GenuineIntel ~2666 Mhz [03]: Intel64 Family 6 Model 29 Stepping 1 GenuineIntel ~2666 Mhz [04]: Intel64 Family 6 Model 29 Stepping 1 GenuineIntel ~2666 Mhz BIOS Version: HP P61, 5/2/2011