Version - SQL Server 2012 SP1 CU3.
I have been using sys.dm_os_volume_stats for a while and it was working. Recently I have not been able to return any result from this DMF on one SQL Server 2012 instance.
SELECT * FROM sys.dm_os_volume_stats(1, 1);
I have no issues with the same code on other SQL Server 2012 or SQL Server 2008 R2 instances. Does anyone know the reason behind and has fixed this problem?