I am working on a Report for CPU/DiskSpace for the past 24hrs of certain Servers. I cannot for the life of me figure out how to specify it for only the past 24hrs and not everything its ever recorded. Please advise.
I ran this query and it was over 33 Million Lines of data so I am not wanting to do that again. Lesson Learned.
SELECT C.NodeID,Caption, INSTRUCTIONS, CPU.Timestamp, MaxMemoryUsed, AvgMemoryUsed, CPU.PercentMemoryUsed, VP.AvgDiskQueueLength
FROM [dbo].[Nodes] AS C
Full JOIN
[dbo].[CPULoad_CS_Daily_hist] AS CPU
ON CPU.NodeID = CPU.NodeID
Full Join
[dbo].[VolumePerformance_Hourly] AS VP
ON CPU.NodeID = VP.NodeID
Full Join
[dbo].[VolumeUsage_CS_Hourly_hist] AS VU
ON VP.NodeID = VU.NodeID
where INSTRUCTIONS = 'Products'