June 2, 2021 at 8:30 pm
I am having an issue in which sp_getschemalock is running with a duration of >= 800ms any time I run a simple select statement on any table in one particular database from a linked server.
The source SQL Server is running 2016 Standard Edition and the destination server is running 2014 Express Edition.
sp_getschemalock runs with 0 duration when running similar select statements on other databases on the same server across the linked server. The same SQL also runs sp_getschemalock with 0 duration on a 2nd PC that has copies of the same databases with the same 2014 Express Edition when ran across a linked server from the same 2016 source SQL Server.
I have compared the linked server, database server, database, and table properties and can find no differences.
Does anyone have any ideas or suggestions of what could be causing this behavior?
June 3, 2021 at 9:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply