Solved

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

Posted on 2015-02-11
6
43 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
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.

 
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

734 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