We help IT Professionals succeed at work.

Server Access Speeds Slow - SQL

Medium Priority
22 Views
Last Modified: 2020-02-26
Hi,

We have a client that is running 1 Physical Server running 3 HyperV machines.

The SQL Server is running slow on all machines when accessing their CRM when generating reports and general navigation (on SQL)

We have been running the "LAN Speed Test (Lite)" Utility to check the speeds of the read and write and they are taking between 25-60 seconds to write a 1Mb file to the SQL Server.

The CRM company have wasted their hands of it as they said it's environmental.

We have checked the latest Windows Updates and none have installed, we have also removed the AV to test and still the same speeds occur.

We have even connected 1 PC and the Server into the router to remove the network switch and still an issue.

Is there anything else we can check?

thanks again
Comment
Watch Question

ste5anSenior Developer
CERTIFIED EXPERT

Commented:
[..] between 25-60 seconds to write a 1Mb file to the SQL Server [..]
What did you test exactly? How did you test it?

You have three main components to test:

- network
- VM cpu/memory
- VM disk I/O

I would test the network with netio or a similar application and test the  between different clients and the server hosting your SQL Server instance. For the VM I would start looking into perfmon, whether there are CPU or memory issues (swapping). And for disk issues you need to look especially at the disk queue length.

Author

Commented:
We used this software to send a 1Mb file to the Server in Question - "LAN Speed Test (Lite)" - https://totusoft.com/lanspeed


I have just opened the SQL CRM on one of the machines to run a report - please see the attached Disk Monitor from the SQL Server

Are these the monitors you mentioned?
01.PNG
CERTIFIED EXPERT

Commented:
You should disclose some hardware parameters, RAM, number of CPUs, disks used. Then you may describe the VM parameters.

You should try to switch VMs off and install SQL Server on the hardware directly and test the speed.

Did you check the Performance Monitor output when working with SQL Server?

Author

Commented:
Hi,

The Server specs are:

Physical Server
ProLiant ML350 Gen10
Intel(R) Xeon(R) Bronze 3106 CPU @ 1.70GHz 1.70GHz, 8192KB Level 2 cache
Intel(R) Xeon(R) Bronze 3106 CPU @ 1.70GHz 1.70GHz, 8192KB Level 2 cache
2x SAS for OS (Raid 1)
3x SAS for Data (Raid 5)
64Gb RAM

VMs
SQL - 20Gb RAM
DC - 20Gb RAM


You should try to switch VMs off and install SQL Server on the hardware directly and test the speed.
 - we dont manage the SQL install it's the development company, however they are just saying it's a 'server' issues and not their Software....no help I know.

Those logs in the comment above are from the SQL Server

thanks again
Scott PletcherSenior DBA
CERTIFIED EXPERT
Most Valuable Expert 2018
Distinguished Expert 2019

Commented:

>> between 25-60 seconds to write a 1Mb file to the SQL Server. <<


"seconds"??  Did you mean milliseconds?  


Give SQL as much RAM as possible,understanding that you have other things on the box.  Does the DC really need 20GB of RAM?  That's genuinely a q, I'm not a DC person, so just because it seems high to me doesn't necessarily mean it is.



Author

Commented:
Hi,

That's actual seconds, not milliseconds,


The systems have been running slow for two days only - this system has been installed for around 12 months with the same specs with no issues.

That's whats odd about the whole situation.

thanks
Scott PletcherSenior DBA
CERTIFIED EXPERT
Most Valuable Expert 2018
Distinguished Expert 2019

Commented:

Verify the hardware.  Sounds like a bad controller or some other physical issue.  Most RAM is self-correcting / self-detecting now, but it wouldn't hurt to verify.

Author

Commented:
Scott - do you mean check the iLO of the Server in the HP IML Logs etc for any errors?

Author

Commented:
Hi Scott

I have just checked the iLO and the IML logs and no errors are showing in here for any hardware issues.

I am on with HP Chat now to confirm everything is ok

thanks
David Johnson, CDSimple Geek from the '70s
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
you have 7 available drive bays - of which you are using 5.  Add an SSD or two in RAID1 and move the SQL database vhd's to the SSD and you will notice a huge difference.
Crystal Disk Mark Sequential results
8 STA drives in Raid 5 get 622 MB/s Read 24MB write
2 SAS RAID 0 208 Read 160 Write
1 NVME SSD 3547 READ/2276 WRITE,
1 SATA SSD 368 Read/77 Write)

Test your system and report the results.

Author

Commented:
Hi David

thanks for the comment but its everything on the SQL Server, not just the SQL database.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.