Which component is your question about?
Lite
Performance Monitor Version
3.1.0
Is your question about how it works, or the results?
How the tool works
What's your question?
Every night we run regression tests on our databases (~50) in Azure SQL db.
We have I have ran the PerformanceMonitor and checked it after the night. Many pages have enough details, it is really great.
But the page Deadlocks is empty. I verified db and see 3 deadlocks using this
WITH CTE AS (
SELECT CAST(event_data AS XML) AS [target_data_XML]
FROM sys.fn_xe_telemetry_blob_target_read_file('dl', null, null, null)
)
SELECT target_data_XML.value('(/event/@timestamp)[1]', 'DateTime2') AS Timestamp,
target_data_XML.query('/event/data[@name=''xml_report'']/value/deadlock') AS deadlock_xml,
target_data_XML.query('/event/data[@name=''database_name'']/value').value('(/value)[1]', 'nvarchar(100)') AS db_name
FROM CTE
order by 1 desc--db_name
GO
Also, I see the errors in the log
Additional Context
No response
Which component is your question about?
Lite
Performance Monitor Version
3.1.0
Is your question about how it works, or the results?
How the tool works
What's your question?
Every night we run regression tests on our databases (~50) in Azure SQL db.
We have I have ran the PerformanceMonitor and checked it after the night. Many pages have enough details, it is really great.
But the page Deadlocks is empty. I verified db and see 3 deadlocks using this
WITH CTE AS (
SELECT CAST(event_data AS XML) AS [target_data_XML]
FROM sys.fn_xe_telemetry_blob_target_read_file('dl', null, null, null)
)
SELECT target_data_XML.value('(/event/@timestamp)[1]', 'DateTime2') AS Timestamp,
target_data_XML.query('/event/data[@name=''xml_report'']/value/deadlock') AS deadlock_xml,
target_data_XML.query('/event/data[@name=''database_name'']/value').value('(/value)[1]', 'nvarchar(100)') AS db_name
FROM CTE
order by 1 desc--db_name
GO
Also, I see the errors in the log
Additional Context
No response