Solved

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

Posted on 2015-02-11
6
35 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)
Comment Utility
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
Comment Utility
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)
Comment Utility
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
The problems with reply email signatures

Do you wish that you could place an email signature under a reply? Well, unfortunately, you can't. That great Exchange/Office 365 signature you've created will just appear at the bottom of an email chain. What a pain! Is there really no way to solve this? Well, there might be...

 
LVL 10

Accepted Solution

by:
tmoore1962 earned 500 total points
Comment Utility
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
Comment Utility
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)
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Several part series to implement Internet Explorer 11 Enterprise Mode
Our Group Policy work started with Small Business Server in 2000. Microsoft gave us an excellent OU and GPO model in subsequent SBS editions that utilized WMI filters, OU linking, and VBS scripts. These are some of experiences plus our spending a lo…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

762 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

7 Experts available now in Live!

Get 1:1 Help Now