Click here to Skip to main content
15,890,282 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Currently I have the following query to monitor a parameter of SQL server 2008 using PowerShell.
SQL
SELECT cntr_value as Mem_KB 
FROM sys.dm_os_performance_counters 
WHERE counter_name = 'SQL Cache Memory (KB)'

I would like to monitor the same with WMI. How is it possible? What would be the corresponding WMI namespaces for it?

I have a few more commands which I want to find out the namespaces. Here are the classes of those commands...
SQL
sys.dm_os_performance_counters
SYS.SYSPERFINFO
sys.dm_os_sys_memory
sys.dm_os_wait_stats

Any help would be greatly appreciated! Thanks in advance!

What I have tried:

I have tried with WMIexplorer.exe and WMICodeCreator.exe
Posted
Updated 9-Mar-16 19:16pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900