This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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'