This sql query tells you if Direct IO is supported on your platform:
select low from spt_values where type='io'
A value of 1 means “Yes, direct io is supported on this platform”.
A value of 0 means “No, direct io is NOT supported on this platform”.
Read this nice post from David Wein about Direct I/O device option.



















