question

André Mendonca avatar image
André Mendonca asked

sp_getschemalock is causing the lock of database servers

The procedure sp_getschemalock is causing the lock of database servers arbitrarily. What is the reason for this blockade? How to avoid it?

databaseblocking
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
dave ballantyne avatar image
dave ballantyne answered

a quick google revealed

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/231b4893-7bf6-4b7b-b072-1338d95c3eeb/

Are you using ssis ?, how is sp_getschemalock being called , and by what ?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered

sp_getschemalock is an internal extended procedure, used when querying across linked servers.

Does this fit with your scenario?

If so what queries are you running?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.