Sample Header Ad - 728x90

Sql Server migration from old server to new very slow SQLEXPRESS

0 votes
0 answers
78 views
Hope someone can assist me. I think I might know what the problem is but this is not really resolving the issue and was wondering if it is even a valid conclusion. I am not a Guru at all with SQL. Running windows sever standard 2019 OLD Server Specs: - 32 gigs ddr4 Dimm Ram - Intel i7-7700 3.6ghz cpu - 1 socket 4 cores / 8 Threads - 1T SSD New Server windows server 2019 date center - 256 Gig DDR4 dimm Ram - Xeon E5 2699 v4 2.2ghz cpu - 2 x sockets 22 x 2 cores =44 /88 Threads - 4x 1.8T Sas Drives Raid 5 (backups) - 5x 1T evo Sata SSD tried raid5 and raid10 (SQL DAtaBase) - 2x 1T samsung evo Nvme Tried mirrored and normal (Windows install) Vms was given a lot and the same quantity of ram then old server bur no improvement. Currently we are running 3 Vms - vm1 AD-DC - vm2 SQL-Database and IIS - vm3 RDS Terminal Working with 4 x 10 gig datebases since sql express is limited to 10gig. Storage configuration - Vm1 AD-DC 1 x V-H drive image stored on (windows drive nvme) 50Gig Storage allocated - vm2 1 x V-H drive for the os 120GIG and 1 x V-h drive for sql data on the raid 10 and raid 5 tested both Samsung evo drives (2.8T storage allocated) - Vm3 - RDS Terminal V-H drive Iso on Sql raid Samsung evo Drive 100gig The VM storage and Virtual h-drives was changed around to test if it might be the raid controller or a drive which was causing the slow responds on retrieving data from the Database. The old and new server are setup the same with the 3 vms same V-h drive configuration and drives used but when trying to load the application we use to access the data It takes forever almost 30 seconds longer and all of the actions when loaded in you click and wait 10 seconds on the new server. Even when all of the VMs and all of the storage are on one physical drive no performance difference. All of the VMS and Host is set to best performance and all of the drivers are installed as per previous discussions. Tried giving all of the VMs double the memory and processors even the SQL VM No difference. **Theory** My Suspicion If it is valid and that is what i want to know is Since SQL Express is limited to 1 gig of memory and 4 processors it does not matter if i give it more but the clock speed between the 2 servers are much different so comparing 4x 2.2ghz with 4 x 3.7ghz The old server will be faster on the SQL EXPRESS in till we upgrade it to the full version where i can assign more processors? Hope this make sense and that i did not leave anything out but if someone can give some advice it will be greatly appreciated. Is the Theory valid?
Asked by Eduard (1 rep)
Mar 19, 2024, 07:40 AM
Last activity: Mar 20, 2024, 06:15 AM