Solved

SBS2008 Server very slow - shows high I/O for SQL

Posted on 2015-02-11
6
36 Views
Last Modified: 2015-12-02
HI

We have an SBS 2008 server which is running very slowly.

General network throughput is very poor (Web speed test shows 0,9mb where clients show 40mb)

Looking at Task Manager, it shows SQL with 6,000,000,000,000 I/O Read bytes and 3,500,000,000,000 I.O Write Bytes

Ive tried to narrow down which DB that is referring to, but cant work it out.

Can anyone shed any light?

Thanks

Steve
0
Comment
Question by:stevie_dee
  • 3
  • 2
6 Comments
 
LVL 38

Expert Comment

by:Hypercat (Deb)
ID: 40603672
SBS uses a SQL database for its monitoring and reporting services, and the Windows Internal Database for WSUS. I doubt very seriously that SQL I/O, which is local to the SBS server, would be causing network throughput to be slow.  Also, read and write I/O measurements are time dependent; IOW, they show the total read/write bytes since the last time the service was started.  If your server (or the sqlserver service) hasn't been restarted for a long time, then those totals wouldn't be that unusual.

When you say "web test speed" versus "client speed" could you describe exactly what kind of testing you're doing?
0
 

Author Comment

by:stevie_dee
ID: 40603688
Hi

We did a speedtest.net on the server and a few clients. On a 50mb UL and 10mb DL service.

Also, when copying a file from a client to the server, copy speeds fluctuate massively. Copying a 50mb file can be anything from 5 seconds to 2 minutes - on a 100mb network.
0
 
LVL 38

Expert Comment

by:Hypercat (Deb)
ID: 40603895
So, you get a significantly different speedtest.net result when you test from your server v. the clients, is that what you're saying?  Have you checked the physical connections from the server to your network - that is, the NIC card, cabling, switch and port that you're using for the server? I would suggest first the simple things - update the NIC card drivers, if they're old, change the cable from the server to the switch, use a different port on the switch if you have one available.  Also, if you have more than one switch, check the uplinks between the switches.
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 10

Accepted Solution

by:
tmoore1962 earned 500 total points
ID: 40604015
check your CPU utilization and avail memory on the SBS server.  Another factor in speed of the server is the type of HDD used on the server.  Are you running SATA, or SCSI and if SATA are they 5400,7200,10K or 15K drives.  What type of RAID if any is used?  But if CPU is low and mem usage high check what is using the most memory, sql will take as much mem as it can as it is supposed to release if needed, but you can set the sql instances memory usage to make memory avail for other processes if you have 24GB ram in system I would limit sql to 4-6GB and since SBS I'd also limit the mail store mem usage you can google for the instructions on how to do both.
0
 

Author Comment

by:stevie_dee
ID: 40604154
All drivers and firmware have been updated, nics have been switched, new cables tried.

Drives are on raid 5 using 10k drives

16gb memory in the server, not overly high usage showing in task manager.

Moving the mouse around on the server also is very jumpy, showing something must be proccessing in the background maybe? Nothing in task manager shows overly high cpu. Network traffic shows a pretty constant 3-4%.

There's about 20 users on the domain uaing exchange and the applications on it.
Just not sure where else to turn!
0
 
LVL 38

Expert Comment

by:Hypercat (Deb)
ID: 40604196
Do you have antivirus/antimalware running on the server as well as workstations?

Check the running process and research anything that looks out of the ordinary.  If you have antivirus/antimalware running on the server be sure that it's being scanned regularly and check to see if anything has been found or there's any indication of a problem.  Also check to see if the scans are by any chance running during the daytime while the server is under a heavier load.  You don't want to have these sorts of background scans running during heavy use hours.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now