Solved

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

Posted on 2013-12-11
7
704 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
  • 4
  • 3
7 Comments
 
LVL 19

Expert Comment

by:jss1199
Comment Utility
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
Comment Utility
It appears the primary thing making the SQL reads is the SBS Monitoring.
0
 
LVL 5

Author Comment

by:Metaltree
Comment Utility
jss1199, how can I verify where it is storing logs, temp and mdf files?
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 19

Expert Comment

by:jss1199
Comment Utility
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
Comment Utility
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
Comment Utility
Safe to disable SQL SBS Monitoring and SBS Manager?
0
 
LVL 19

Accepted Solution

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

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
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…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

728 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

14 Experts available now in Live!

Get 1:1 Help Now