• State Verified Answer
  • Replies 4 replies
  • Subscribers 26 subscribers
  • Views 968 views
  • Users 0 members are here
Options
Related

SQL Managed Instance - No deadlocks detected in this time interval.

wheater

Hi All,

I'm currently monitoring a number of SQL Server Managed Instances with DPA version 2022.3.7963, and the deadlock tab always displays No deadlocks detected in this time interval, even when I know there have been deadlock events during the selected time period. I've verified this by logging onto the server and manually checking the dpa_deadlock_capture xevent.

Other, non SQL Server Managed Instances are showing deadlocks within DPA, so the issue seems to be isolated to only Managed Instance environments. 

I'm going to look at deploying the latest DPA version to see if that fixes the issue, but in the meantime, has anyone seen this before or have any suggestions in case it's not a version related issue?

Thank you Slight smile

Tom

Parents
  • 0

    We have had a number of cases on this issue now in support and in most all there is a time out of the query to the dpa_deadlock_capture data when trying to poll it to the DPA web console. 

    So just as you say the data is collected and not displayed. Internal tracking of the issue is in DPA-8713. the error for the query time out is clear in DPA's idc.log file. 

Reply
  • 0

    We have had a number of cases on this issue now in support and in most all there is a time out of the query to the dpa_deadlock_capture data when trying to poll it to the DPA web console. 

    So just as you say the data is collected and not displayed. Internal tracking of the issue is in DPA-8713. the error for the query time out is clear in DPA's idc.log file. 

Children
No Data

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.