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

Improve this question
2
  • I don't think resmon is the right tool to assess SQL Server performance issues. Commented Dec 19, 2018 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. Commented Dec 19, 2018 at 17:27

1 Answer 1

Reset to default
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.

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.