[sims] New server upgrade sql 2014 slower

[forkies]

Hi all,

 

Looking for some insight/advice.

 

We have recently bought a new server to replace our existing ESXi 4.1 host which hosts our Sims server.

 

Currently esxi 4.1 2008r2 with 2008r2 SQL, 4 core cpu, 24GB ram, 10K drives. 2 x NICs in load balance.

 

migrating to esxi 5.5u2 2012 with 2014 SQL, 8 core cpu, 32GB ram, SSD data store (correctly configured in esxi) and a 10k data store for OS, 2 x NICs in load balance. VM swap file is on SSD datastore. Page file is configured as per MS guidelines. I have put the docserver on the ssd data drive too.

 

However it is still slower then the current server? Running general reports it is about a second slower, SQL is showing barely any usage. I have tried changing everything about the config of the server and where everything is stored included putting the OS on the SSDs but nothing is making it the same speed as our existing server.

 

Is there something I am missing or something that might speed it up? We are migrating for real over half term, I know the speed isn't that noticeable but I would of at least expect a server of this spec to be the same as the old one! Maybe something to do with it being SQL 2014?

 

Any input would be greatly appreciated.

[matt40k]

Phone your SIMS support team. They'll send you the reindexing patch.

[forkies]

Phone your SIMS support team. They'll send you the reindexing patch.

 

Thanks, I have got the reindexing patch deployed to us. I will run it on the new server when we fully migrate over half term.