I am trying to get the Lazy writes/sec value in SAM using SQL for one of the database and I am getting "unable to convert query result".
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'
Any idea on this what I am missing here?