In my splunk log record, I find deadlock issue happening every 10 minutes
{"@l":"Information","@mt":"{@Response}","Response":{"Uri":"http://mytdeliveryopsapi.tesla.cn/api/widget/finance/Info/RN802421737","Path":"/api/widget/finance/Info/RN802421737","Body":"{\"Data\":null,\"Success\":false,\"ErrorData\":{\"FriendlyMessage\":\"System.Data.SqlClient.SqlException (0x80131904): Snapshot isolation transaction failed in database 'WarpDelivery' because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction. It is disallowed because the metadata is not versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation.\n at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__126_0(Task1 result)\\n at System.Threading.Tasks.ContinuationResultTaskFromResultTask
2.InnerInvoke()\n at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)\n--- End of stack trace from previous location ---\n at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)\n--- End of stack trace from previous location ---\n at Dapper.SqlMapper.QueryRowAsync[T](IDbConnection cnn, Row row, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 473\n at DeliveryOpsAPI.Repository.WarpDelivery.CustomerReadinessRepository.GetReadinessDetailAsync(String referenceNumber) in /app/src/DeliveryOpsAPI.Api/Repository/WarpDelivery/CustomerReadinessRepository.cs:line 126\n at DeliveryOpsAPI.Service.WarpDelivery.WidgetService.GetFinanceOfferAsync(String referenceNumber, GetFinanceOfferRequest request, String email) in /app/src/DeliveryOpsAPI.Api/Managers/WarpDelivery/WidgetService.cs:line 1126\nClientConnectionId:153acfb9-cde1-40f3-b721-ed6afbadc390\nError Number:3961,State:1,Class:16\nClientConnectionId before routing:c5aa4d18-0061-48e2-86b7-b558221248d6\nRouting Destination:PVG03P1WRPDB02.teslamotors.com,1433\",\"InternalErrorMessage\":\"System.Data.SqlClient.SqlException (0x80131904): Snapshot isolation transaction failed in database 'WarpDelivery' because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction. It is disallowed because the metadata is not versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation.\n at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__126_0(Task1 result)\\n at System.Threading.Tasks.ContinuationResultTaskFromResultTask
2.InnerInvoke()\n at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)\n--- End of stack trace from previous location ---\n at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)\n--- End of stack trace from previous location ---\n at Dapper.SqlMapper.QueryRowAsync[T](IDbConnection cnn, Row row, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 473\n at DeliveryOpsAPI.Repository.WarpDelivery.CustomerReadinessRepository.GetReadinessDetailAsync(String referenceNumber) in /app/src/DeliveryOpsAPI.Api/Repository/WarpDelivery/CustomerReadinessRepository.cs:line 126\n at DeliveryOpsAPI.Service.WarpDelivery.WidgetService.GetFinanceOfferAsync(String referenceNumber, GetFinanceOfferRequest request, String email) in /app/src/DeliveryOpsAPI.Api/Managers/WarpDelivery/WidgetService.cs:line 1126\nClientConnectionId:153acfb9-cde1-40f3-b721-ed6afbadc390\nError Number:3961,State:1,Class:16\nClientConnectionId before routing:c5aa4d18-0061-48e2-86b7-b558221248d6\nRouting