Hi,

We can use Dynamic Management Views to monitor performance

'sys.dm_os_performance_counters' This DMV makes it possible to query a view directly to capture the SQL Server counters related to the instance

Regards,

Jagadeesan