Friday, April 12, 2013

Disabling IdlePrioritySupported for dedicated SQL Server LUNs?

Disabling disk IO priorities per Windows drive by setting IdlePriority = 0 in the registry is mentioned on page 53 of "Performance Tuning Guidelines for Windows Server 2012" (http://msdn.microsoft.com/library/windows/hardware/jj248719) and also in " Performance Tuning Guidelines for Windows Server 2008 R2" (http://msdn.microsoft.com/en-us/library/windows/hardware/gg463392.aspx).

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\DeviceClasses\{Device GUID}\DeviceParameters\Classpnp\IdlePrioritySupported

I haven't seen comparative test results yet, and also haven't performed my own tests yet. But, trying to crank nightly ETL as fast as possible (without pressuring other systems on shared storage :) ).

I'll update this post later with what I find from the testing of others, or what we see in our own testing.

No comments:

Post a Comment