For our database I have PowerShell scripts that automate updating tables with data it is pulling from other sources and applications. These mainly run overnight, but sometimes run over into the morning. What happens occasionally in this scenario is when browsing and reading records in the UI we might get an error that the data can't be retrieved because the transaction was deadlocked.
How can I change the deadlock priority of browsing and reading records in the UI so that it takes priority over the script updating fields? Or, if that can't be changed what is the default deadlock priority of a browse/read via the UI? Perhaps I can change the priority on the scripts? There are multiple scripts that run and there is logic built within them to detect deadlocks between them and retry, so if a record is being read and is set to a higher priority the script will retry that record again until successful and not fail.
Thoughts?
