Forum Discussion
Checking 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,
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