The procedure sp_getschemalock is causing the lock of database servers arbitrarily. What is the reason for this blockade? How to avoid it?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by dave ballantyne · Nov 06, 2009 at 04:49 PM
a quick google revealed
Are you using ssis ?, how is sp_getschemalock being called , and by what ?
Answer by Kev Riley · Nov 06, 2009 at 01:13 PM
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?
Answers Answers and Comments
No one has followed this question yet.
Manage max table storage space in case of excess data (size in GB)
Between EXISTS and In which one is more performance friendly ?
How do I parse the xml part of a database mail to a table?
Database mirroring login failed
Deleting DB entries