donhauro
Reputation: 62
sys.dm_exec_query_stats returns only a few rows
What is the reason, that select * from sys.dm_exec_query_stats returns only a few rows? The record count differs from 3 to 30.
On different server/machine I get more than 8.5k rows. Is this an indicator for memory pressure?
Upvotes: 0
Views: 865
Answers (1)
Related Questions
- SQL Server query success but no results
- query executed successfully but did not return number of rows SSMS 18.3.1
- Querying dm_db_index_usage_stats returns empty row
- Select returns no rows - queries in trace file
- SQL server not returning all rows
- SQL Query Count, From, Not Equal to
- SQL query not returning all rows
- sys.dm_exec_procedure_stats - am I interpreting it correctly
- SSMS returning only partial results
- sys.dm_exec_query_stats column descriptions?