collecting performance counter system using DMVs

Miiimy7 41 Reputation points
2021-03-26T08:32:59.673+00:00

Hello,

i want to find all perfmon counters just using DMVs. With sys.dm_os_performance_counters i obtain just SQL Server counters. But thing is, i also want performance counters system for these categories CPU, LogicalDisk, Memory, Network,...
First, is it possible?
Second, if it is then can you help me please?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,620 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,546 questions
0 comments
Accepted answer
  1. Olaf Helper 40,656 Reputation points
    2021-03-26T11:59:53.82+00:00

    SQL Server knows only it's own performance counter, see sys.dm_os_performance_counters => Returns a row per performance counter maintained by the server
    How should SQL Server be aware of performance counter of other applications like MS Exchange?

    You have to use other tools to track performance counter of your interest, like PerfMon, PowShell, etc.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest