Solved

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

Posted on 2015-02-11
6
39 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
Back Up Your Microsoft Windows Server®

Back up 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

765 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