I was experiencing a deadlock so I set up a trace flags as well as profile trace to capture a deadlock. During this exercise I found something interesting. In the profile trace I noticed that "sa" login name acquired an IX lock on one of the objects (table) involved in the query. I have WITH (NOLOCK) on every table.
An interesting thing is that this particular lock is always acquired few seconds later after all of the other locks have been acquired.
Any ideas why this "sa" would issue an IX lock on the object?
The query is being executed from SSMS. Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64).