Post reply

OpenQuery with Application Intent specified runs on primary node.

  • June 13, 2025 at 10:22 am

    #4607020

    I have an Open query that runs on an Always On server via a linked server and does selects * only.

    Select * into #Temptable from openquery (linked server)

    The linked server in its connection properties specifies application intent as ReadOnly, so this query should run on the secondary node but we find that it runs on the primary node.

    Has anyone experienced a similar issue and know why does this happen?

    Thanking you in anticipation.

  • June 14, 2025 at 11:10 am

    #4607556

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • June 16, 2025 at 2:36 pm

    #4608458

    I think the issue is with the Linked Server setup as it specifies application intent as ReadOnly but Catalog is set to Master database where as it should be a database which is in AG for read routing to work is that not correct?

     

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply