question

Miiimy7-1570 avatar image
0 Votes"
Miiimy7-1570 asked OlafHelper-2800 answered

collecting performance counter system using DMVs

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-generalsql-server-transact-sql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.