OS disk time on Disk "I" is currently 100.00%

by Jul 27, 2016

What might be causing this disk to generate 100% disk time? The only data that I have on this disk is SQL backups which are run at night? And yes I have another backup source that backs up the data periodically through out the day. Otherwise this disk is not being used.

 

I am running

Windows 2012 R2

SQL Server 2014,

SQL Diagnostic Manager:

IDERA SQL Diagnostic Manager Desktop Client    10.0.2.2261
IDERA SQL Diagnostic Manager Repository    10.0
IDERA SQL Diagnostic Manager Management Service    10.0.2.2261
IDERA SQL Diagnostic Manager Collection Service    10.0.2.2261
Microsoft Data Access Component (MDAC)    6.1.7601.17514
Microsoft .Net Framework    4.0.30319.42000
Microsoft Windows Operating System    Microsoft Windows NT 6.1.7601 Service Pack 1
SQLDM Mobile and Newsfeed Version    1.4.15.12

 

Thank you.

Jon Lellelid

Responses

It could be
– a virus scanner doing a disk scan?
– a disk defragmentation job?
– a disk backup job (as you already mentioned)

If it is every day at the same time, you could use the taskmanager to find the process that generates a lot of disk I/O.
Or consult the windows event logs and browse for events during the high I/O timeframes.
Or you could ask your Server Admin, maybe he’s got a clue.

Cheers,
Daniel

Is this a virtual server? How much memory is allocated to the virtual server? Is it a numa node? Make sure the VM is configured as 1 CPU XX cores instead of multi CPU and 1 core each. If you have over 64GB ram on the server, try allocating a little less to SQL – make sure you follow the 10 percent rule… after that, if you don’t have much history for this specific server go ahead and delete the server and the data for it…and then re-add it, and see if the problem goes away. I fixed a similar issue I was having…

Response

Daniel K over 6 years ago
It could be
– a virus scanner doing a disk scan?
– a disk defragmentation job?
– a disk backup job (as you already mentioned)

If it is every day at the same time, you could use the taskmanager to find the process that generates a lot of disk I/O.
Or consult the windows event logs and browse for events during the high I/O timeframes.
Or you could ask your Server Admin, maybe he’s got a clue.

Cheers,
Daniel

sqlAllstar over 6 years ago
Is this a virtual server? How much memory is allocated to the virtual server? Is it a numa node? Make sure the VM is configured as 1 CPU XX cores instead of multi CPU and 1 core each. If you have over 64GB ram on the server, try allocating a little less to SQL – make sure you follow the 10 percent rule… after that, if you don’t have much history for this specific server go ahead and delete the server and the data for it…and then re-add it, and see if the problem goes away. I fixed a similar issue I was having…