The Toad background query below is sometimes an idle blocker, blocking a query from SSMS Intellisense:
Toad needs to commit its transaction or close its session in a timely manner.
In SolarWinds Database Performance Analyzer, one shows the blocking chain for a specific incident and another shows the result of clicking on the Last Activity link for the idle blocker. Note that the Toad query ran in less than a second, but was blocking sessions even when well past its finish time.
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center