SELECT pcd.Counter ,pcd.Instance ,pcd.Category ,CONVERT(datetime, SWITCHOFFSET(CONVERT(datetimeoffset, pc.[LogTime]), DATENAME(TzOffset, SYSDATETIMEOFFSET()))) AS LogTimeLocal ,pc.[LogTime] as LogTimeUtc ,pc.[MachineName] ,pc.[CounterId] ,pc.[Value] FROM [SP_ContentUsage].[dbo].[PerformanceCounters] pc join [SP_ContentUsage].[dbo].PerformanceCountersDefinitions pcd on pcd.Id = pc.CounterId where pcd.Counter = 'Available Mbytes' -- where pcd.Counter = '% Processor Time' order by pc.MachineName, pc.RowCreatedTime