Forum Discussion
Post ProdigyChecking query duration using the sys.dm_exec_requests dmv
Hi pmscorca you could try the DMVs in the queryinsights schema as dm_exec_sql_text is not supported in Fabric Warehouse (sys.dm_exec_sql_text (Transact-SQL) - SQL Server | Microsoft Learn)
SELECT * FROM queryinsights.exec_requests_history WHERE command = 'select * from mytable'
HI pmscorca,
I agree with AndyDDC's point of view, use DMVs should more suitable for your requirement to check these executed query requests.
If the full query can't get expected results, you can split these query string and use fuzzy search to check these keywords. (e.g. WHERE command LIKE '%SELECT *%' and command LIKE '%mytable%')
In addition, if you remove conditions from the query, can you query data from these used tables?
Regards,
Xiaoxin Sheng
Hi pmscorca ,
Any update on this? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng