This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 89%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
I'm getting the below on some exactions of a certain query. It was working fine on an older SQLServer 2019 install on another server. However after I restored the DB to this server it started randomly failing - about 1 in 3 requests.
There query itself is quite complicated as it's using several joins, cross DB and making use of spatial indexes.
Additional SQL Server features and topics not covered by specific categories
This type of crashes are often a token of a bug in SQL Server They are best resolved by opening a support case. It is not really much we can do here in the forums to help you.
I note that there are CLR on the stack dump, but since you say that the queries uses spatial, that seems quite normal.