Post reply

linked server queries being blocked by local function calls on sysschobjs

  • January 19, 2011 at 2:58 pm

    #243979

    I've seen some blocking happened on linked server queries like:

    select * from DB1.mydb.dbo.table1 with (nolock) where....

    The remote query seems to call sys.sp_check_constbytable_rowset on DB1. Which gets blocked by some scalar functions on DB1. The contention shows on sysschobjs. But the scalar function does not explicitly reference sysschobjs. I am just wondering if under the cover, functions actually query sysschobjs, sysobjects, etc? But I don't know how/why.

  • November 8, 2011 at 3:04 am

    #1404328

    Did you get any solution or article that describes the problem and the solution? Recently, I have also started seeing the similar issue. It would be helpful in case it was fixed before.

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

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