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
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
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.
ASKER
It appears the primary thing making the SQL reads is the SBS Monitoring.
ASKER
jss1199, how can I verify where it is storing logs, temp and mdf files?
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
ASKER
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.
ASKER
Safe to disable SQL SBS Monitoring and SBS Manager?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.