The most recent content from our members.
It is quite difficult to find sessions that have been running in a certain time period under the TopSQL tab. Because the Running Queries tab always shows active sessions at the current time and it is not possible to see that a query was running actively in a time period in the past in retrospective examinations. Only when…
When selected a SPID on Blocking/deadlock tab, we can not jump to same SPID’s query on topsql tab. It forward us to random query in same time range but not matched SPID. After that we search/filter that query to find the details, It takes some time when critical problem happened.
It looks like you're new here. Sign in or register to get started.