azure sql database – Linked Servers and Application Intent
I’m attempting to improve performance of a set of views that we have on a local server, pulling data from an Azure database.
Our system provider advised us to use ApplicationIntent=ReadOnly
, but can we optimise these queries further by using tempdb
space on the remote server to create temporary tables, if read only is set?
I read this answer, which does help a little, but would appreciate any straightforward answers on this.
Please note, I’m not a DBA, so my knowledge is pretty limited. Thanks in advance.
Read more here: Source link