Adding handling for errors in Azure SQL DB

amachanic / sp_whoisactive

sp_whoisactive

GNU General Public License v3.0

1.18k stars 290 forks source link

Adding handling for errors in Azure SQL DB #85

Open Tyoung97 opened 2 years ago

Tyoung97 commented 2 years ago

Adding handling for additional information that is added to sys.sysprocesses.waitresource when the wait type is Page_Latch in Azure SQL DB. The additional info causes parsing blockers to throw the following error 'Conversion failed when converting the nvarchar value ' 1)' to data type int.'

zachproffitt commented 1 year ago

We're seeing this periodically on multiple Azure SQL databases as well. @amachanic are you planning to pull this into a future release?