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 184.108.40.206
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.
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…