Hello!
i want to monitor SQL Server in SQL Server (without using Perfmon), so i'll be using sys.dm_os_performance_counters. There's a lot of counters returned by this DMV.
First problem is i don't know which one are important.
Second problem is i don't know if it is enough to monitor SQL Server (SQL Server system included: CPU, Network, System,Disk,Memory,etc.) or do i need other DMVs
Third problem is : by listing counters in one CTE, i don't know what values to put on instance name.
Can you guys help me?
Thanks