I have a SQL Server 2017 instance that seems to be running a bit slowly. CPU and Memory usage looks to be normal, but disk usage might be a bit high. The data files are on disk E and the log files are on disk F. Does "Highest Active Time" pegged at 100% on the data disk indicate the need for faster drives, or to split the data files across additional disks?

enter image description here

  • I don't think resmon is the right tool to assess SQL Server performance issues. – Greg Askew Dec 19 '18 at 17:24
  • 1
    I'd be more interested in seeing disk queue length counters in perfmon for the disk in question. Also in seeing some SQL specific perfmon counters. – joeqwerty Dec 19 '18 at 17:27

Not necessarily. You should take a look at the Activity Monitor first to see what queries are running towards the database. See more here: https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/open-activity-monitor-sql-server-management-studio?view=sql-server-2017.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.