Hi All,
I have a bit of a strange one...I have a Windows Server 2016 Standard Edition with SQL Server 2016 Developer Edtion running on an old HP Server as a Virtual Machine.. This is our test environment, we have a special script that was created by one of our Developers that sanitises a specific DB, this script on the old server takes about 1hr 30mins to complete.
However, we built a new server in our new environment, its effectively a private cloud using brand new servers, faster CPU's, storage, memory, network.....Pretty much everything is newer and faster....hehe...
So we built a new Virtual Server with 64GB RAM and 6 CPU's to run purely this script as we need to sanitise a lot due to Developers needing copies of a DB to test fixes..etc..
However the new server is taking 3 times longer to run this script, which is baffling. I compared TEMPDB config, the model DB config and made sure all the parameters were identical to the old Heritage Server with regards to autogrowth..etc.
I know i am asking a bit of sweeping question, but I am at my wits end...So looking to hopefully start a conversation with people dramatically more in the know than me. I am happy to supply any information that I can to get help.
Anyone up for a challenge?
Regards
John