DMVs are Dynamic Management Views in SQL Server. DMVs store metadata and important statistics related to SQL Server performance.This information gets updated at runtime so that user can get the most recent values in order to analyse server performance and usage. DMVs greatly assist in analysing system performance issues and diagnosing problems in SQL Server at any time.
Questions tagged [dmv]
96 questions
-1
votes
1 answer
Really slow DISCOVER_CSDL_METADATA in SQL Server Profiler
Our setup is SQL Server + SSAS + multidimensional OLAP + PowerBI on top of it.
Recent issue we noticed is that when user loads PowerBI report, from time to time forementioned event occurs. This leads to really long waiting time until the report…
Marcin
- 137
- 1
- 10
-1
votes
1 answer
How to execute a DMV query in SSAS through a powershell runbook from Azure Automation?
I am trying to open a connection with a ssas server and execute a dmv query in order to extract table metadata, through a powershell runbook from an Azure Automation Account.
I have already written and tested a powershell script that seems to work…
-1
votes
1 answer
Which DMV to get database id for sys.dm_os_waiting_tasks
Which DMV do I have to join with sys.dm_os_waiting_tasks to get the database ID?
xhr489
- 1,957
- 13
- 39
-1
votes
2 answers
DMV DISCOVER_CALC_DEPENDENCY suddenly broken on SSAS Tabular, how to debug/fix?
Just started using DMVs on a tabular SSAS instance and after a cube re-work, DISCOVER_CALC_DEPENDENCY suddenly stopped working. It now returns an unexpected error.
Swear to god, this used to work : https://i.stack.imgur.com/f6mmH.jpg
Where can I get…
Simon Benoit
- 1
- 2
-1
votes
1 answer
is there a way to identify a query that has been cancelled?
I was running some big updates and while checking what else was running on that server, I saw an expensive query running, I then asked my friend who was running spid 91 if he could stop it, then he cancelled his query but there was no way I could…
Marcello Miorelli
- 3,368
- 4
- 44
- 67
-1
votes
1 answer
Performance impact of querying SQL server DMVs
Is there any performance impact on a busy production SQL Server 2008 when I query DMVs such as sys.dm_exec_query_stats, sys.dm_tran_locks, or sys.dm_db_index_physical_stats ?
Thanks
PyQL
- 1,830
- 3
- 18
- 22