Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 732
  • Last Modified:

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

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
Metaltree
Asked:
Metaltree
  • 4
  • 3
1 Solution
 
jss1199Commented:
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
 
MetaltreeAuthor Commented:
It appears the primary thing making the SQL reads is the SBS Monitoring.
0
 
MetaltreeAuthor Commented:
jss1199, how can I verify where it is storing logs, temp and mdf files?
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
jss1199Commented:
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
 
MetaltreeAuthor Commented:
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
 
MetaltreeAuthor Commented:
Safe to disable SQL SBS Monitoring and SBS Manager?
0
 
jss1199Commented:
yes, if you do not care for the feature / data, safe to disable.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now