Hi Anuj,
Here's a little query you could probably use, although it relies on the qos_views script already been run.
The qos_views script is available elsewhere on this community, version 3.1 is current I think for mssql.
You need to put in your origin (or remove that line)
It calculates the average per day because memory and cpu might come in with different timestamps so difficult to match to the same line.
You could change it to hourly averages if you need more detail.
cheers
Rowan
select a.customer
,a.source
,a.Date2
,CONVERT(DECIMAL(10,2),a.cpu) as cpu
,CONVERT(DECIMAL(10,2),b.mem) as memory
from
(
SELECT cpu.origin as customer
,cpu.source as source
,CONVERT(char(8), cast(cpu.sampletime as datetime), 112) as Date2
,avg(cpu.samplevalue) as cpu
FROM [CA_UIM].[dbo].[V_QOS_CPU_USAGE] CPU
where CPU.origin = 'rc82_phub'
group by CONVERT(char(8), cast(cpu.sampletime as datetime), 112), cpu.source,cpu.origin
) a
full join
(
SELECT mem.origin as customer
,mem.source as source
,CONVERT(char(8), cast(mem.sampletime as datetime), 112) as Date2
,avg(mem.samplevalue) as mem
FROM [CA_UIM].[dbo].[V_QOS_MEMORY_PHYSICAL_PERC] mem
where mem.origin = 'rc82_phub'
group by CONVERT(char(8), cast(mem.sampletime as datetime), 112), mem.source,mem.origin
) b on a.customer = b.customer and a.source = b.source and a.date2 = b.date2
order by a.date2 desc