Posted by m.bohse on 10/19/05 13:54

I had a similar issue and it turned out that some scrappy application
held thousands of locks on the tempdb. Run sp_who2 in combination with
sp_lock to see which process is blocking the MOM agent.

M

• Next in forum: Derived tables from multiple resultsets
• Prev in forum: Re: sum of sums
• Thread view: Re: MOM blocking analysis

[Reply to this message]