Is there any way to create custom report for Buffer manager Lazy writes/sec in DPA

I have SQL query for Buffer manager Lazy writes/sec, can I use the same query in DPA and create a custom report in table format, if yes then how can I create a report in table format.?

Below is the SQL query:

SELECT object_name, counter_name, cntr_value, cntr_type
FROM sys.dm_os_performance_counters
WHERE [object_name] LIKE '%Buffer Manager%'
AND [counter_name] = 'Lazy writes/sec'

Parents Reply Children