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?
Asked
Active
Viewed 1,230 times
0
-
I don't think resmon is the right tool to assess SQL Server performance issues. – Greg Askew Dec 19 '18 at 17:24
-
1I'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 Answers
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.
![](../../users/profiles/502069.webp)
Eyal Traitel
- 1
- 1