0

Resource Monitor on our SQL Server DB server shows very high fluctuating disk activity that I cannot understand. I then check Activity Monitor and the Database I/O looks ok.

Any ideas why I am seeing such a difference? Thanks

Resource Monitor

Activity Monitor

James Anderson
  • 5,794
  • 2
  • 27
  • 43
K09
  • 1,454
  • 13
  • 39
  • 61

2 Answers2

4

If I read your graph correctly, your resource monitor shows the Disk I/O peaking at around 10MB/sec. That is not much and would correspond to the I/O graph from the activity monitor.

So, in my opinion, both images show the same data, only on a different scale.

Twinkles
  • 2,371
  • 1
  • 18
  • 25
-1

It can be due to many reasons like: some process/procedure, large data chunk fetch ..etc. So just to answer the part - "Any ideas why I am seeing such a difference?" I think these will give you some insight:

http://mlichtenberg.wordpress.com/2013/04/05/sql-server-finding-the-source-of-excessive-io/

High Disk I/O from sql server or is High disk I/O slowing sql server?

http://sqlmag.com/database-performance-tuning/your-physical-disk-io-affecting-sql-server-performance

https://stackoverflow.com/questions/2199524/sql-server-high-cpu-and-i-o-activity-database-tuning

Community
  • 1
Ahsanul Hadi
  • 1
  • 1