0

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

darthg8r
  • 243
  • 2
  • 8
  • 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

1 Answers1

0

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.

Eyal Traitel
  • 1
  • 1