emeadaxsupport: Optional Additional Installation Script for Blocking Analysis with DynamicsPerf v2.0

[Blog bot]

Источник: https://blogs.msdn.microsoft.com/axs...micsperf-v2-0/
==============

In relation to the analysis scripts that come with DynamicsPerf (Performance Analyzer) v2.0, (based on the new extended events being used in place of the SQL profiler trace which featured in v1.20), i.e.: … —            BLOCKING_EVENTS — Blocking events sorted by TIME desc —————————————————————- SELECT TOP 100 * FROM (SELECT event_data.value(‘(event/@name)[1]’, ‘varchar(50)’) AS EVENT_NAME, DATEADD(hh, DATEDIFF(hh,... Read more

Источник: https://blogs.msdn.microsoft.com/axs...micsperf-v2-0/