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
Comments