Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement