SQLTeam.com | Weblogs | Forums

Sys.dm_exec_query_stats no record

sql2014

#1

Hi,
We have sql server 2014 cluster 3A 1P,
and I find only 1 instance can return records when I use sys.dm_exec_query_stats ,sys.dm_exec_sql_text,
sys.dm_exec_query_plan to get query performance for CPU .
And same result from SQL Dashboard Reports in SSMS .
Is anyone can help me with this problem?