Solved

SBS 2011 - High Disk Queue Length - 2.7 TB NTFS logical drive?

Posted on 2013-12-11
7
724 Views
Last Modified: 2013-12-19
I've inherited a SBS2011. The server is extremely slow and I've pinned it down to disk issues.
I've attached screenshots of PerfMon, HP Array Config, and diskmgmt.

CPU & Memory usage never seems to be excessive, avg memory is about 35% and avg cpu is about 7%

Any advice on where to even start to resolving these disk issues? They do use SQL on this server which obviously has the highest total reads. Otherwise its hit or miss as to what is using Disk Activity.
diskmgmt.JPG
hparray.JPG
perfmon.jpg
0
Comment
Question by:Metaltree
[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
  • 4
  • 3
7 Comments
 
LVL 19

Expert Comment

by:jss1199
ID: 39712526
Add disks.  SQL best practice is to separate logs, temp, and mdf - it doesn't appear this has been done. Be sure to actually add disks, though, and not simply repartition.
0
 
LVL 5

Author Comment

by:Metaltree
ID: 39712555
It appears the primary thing making the SQL reads is the SBS Monitoring.
0
 
LVL 5

Author Comment

by:Metaltree
ID: 39712559
jss1199, how can I verify where it is storing logs, temp and mdf files?
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 19

Expert Comment

by:jss1199
ID: 39712564
Not surprising.  If it is not used, you can turn off the SBS Monitoring function through the SBS console - that should stop the writes to its database
0
 
LVL 5

Author Comment

by:Metaltree
ID: 39712569
There is also quite a heavy load from a program called foundation which uses reporting services, I know they use this but i can't seem to see it where the Disk Activity is saying it is.
0
 
LVL 5

Author Comment

by:Metaltree
ID: 39712597
Safe to disable SQL SBS Monitoring and SBS Manager?
0
 
LVL 19

Accepted Solution

by:
jss1199 earned 500 total points
ID: 39712618
yes, if you do not care for the feature / data, safe to disable.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

pc, laptop  monitor connection configurations
This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Suggested Courses

630 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