I am new to the forum and seeking some advise. I have recently being assigned to manage a site with a huge SQL network. The problem we are experiencing is SQL processing suddently slows down during the course of the day.
The SQL server is running on Windows Server 2012 R2 with 64GB of RAM and 5 Virtual Cores and running on RAID 5 SSDs and 20Gbps network (2x 10Gbps NIC Teaming).
What we did is moved the server to brand new host and since then it has slowed down. All the configuration is exactly the same as it was before.
We did try up the CPU cores and give more memory and even set the host to priorities the resources, but that didnt help.
Is there anything we can do to resolve this issue?
Hope to hear some suggestions soon.