Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 msmq and xp_userlocks

Author  Topic 

ferrethouse
Constraint Violating Yak Guru

352 Posts

Posted - 2015-03-18 : 11:07:03
Hi all,

We started using msmq recently and I've noticed new waits (and locks) in my database monitoring tool called xp_userlock. It is a constant amount every hour and I'm not aware of any user complaints or other performance problems. I'm thinking this is just an accepted overhead of msmq. Anyone come across this before?

Thanks.
   

- Advertisement -